csv to dbf

Treenewbee 2013-09-15 12:27:49
各位数据库高手请教将数据从CSV格式转换为DBF格式,sql语句如何写呢?
比如c:\a.csv内容:

company plan_type deductible
Empire HealthChoice Assurance Inc Indemnity $0
EmblemHealth PPO $0
Oxford NY PPO $2,850
Oxford NY EPO $2,000
Empire HealthChoice HMO Inc HMO $0
Easy Choice Health Plan of New York HMO $0
Oxford NY PPO $2,000
EmblemHealth EPO $1,250
Easy Choice Health Plan of New York HMO $0
Oxford NY EPO $2,000
EmblemHealth EPO $1,250

转换为b.dbf,VB6,VBA的sql语句该怎样写呢?

...全文
101 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
Treenewbee 2013-09-26
  • 打赏
  • 举报
回复
多谢!已解决。
Andy__Huang 2013-09-15
  • 打赏
  • 举报
回复
导入导出大全: http://blog.csdn.net/hdhai9451/article/details/215201
QueryRun Data Easy Export Run(DEE) is a powerful program to export your data quickly from databases to any of 14 available formats, including MS Access (Windows version only), MS Excel, MS Word (RTF), HTML, XML, PDF, TXT, CSV, DBF and more. QueryRun Data Easy Export Run includes a wizard, which allows you to set export options for each table visually (destination filename, exported fields, data formats, and many others) and a command line utility to export data from tables and queries in one-touch.Version 2006 Key features: · Conceptually new user-friendly wizard interface · Three languages available: English, Japan, Chinese · Exporting to 14 most popular formats: MS Excel, MS Access, MS Word, RTF, HTML, PDF, XML, TXT, DBF, CSV, SYLK, DIF, LaTeX and SQL · Exporting data from several objects from different databases on one host · Exporting data from tables, views and queries · Can exec procedure before data export · Selecting fields to export and changing their order · Adjustable parameters for each exported table and specific parameters for export to MS Excel, MS Word / RTF, MS Access, HTML, TXT, CSV, PDF, XML and SQL · Possibility of saving all the export parameters, set on current wizard session · Command-line utility to export data using the configuration file · Powerful visual options module · Export files can be stored in standard Zip (Zip64 compatible) format,Zip_files can be protected with a password · Supports inclusion and exclusion of files by wildcard mask as well as by exact file name · Has its own scheduler supporting unattended auto-Export and scheduling of any specific time or date, day of the week or month · Supports FTP, all types of LAN and UNC file path names (Network folders) · Can notify user through email when Export operation have finished

1,216

社区成员

发帖
与我相关
我的任务
社区描述
VB 数据库(包含打印,安装,报表)
社区管理员
  • 数据库(包含打印,安装,报表)社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧