csv to dbf
各位数据库高手请教将数据从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语句该怎样写呢?