将text文件转换成access文件的原码如下: 'open text file open "text1.txt" for input as #1 'read data line #1,m_str close(1) 'create database set db_exp=workspaces(0).createdatabase("path/filename") 'create table set tb_exp=db_exp.createtable("tableanme") 'create fields 'create index 'then db_exp.execute "INSERT INTO tablename " _ & "(fields list[,])" _ & " VALUES(" & m_str & ");" 'close database db_exp.close酷吧,还有E文解释,因为过几天要进行四级考试,所以练练。 给分吧?
再转入access。
'open text file
open "text1.txt" for input as #1
'read data
line #1,m_str
close(1)
'create database
set db_exp=workspaces(0).createdatabase("path/filename")
'create table
set tb_exp=db_exp.createtable("tableanme")
'create fields
'create index
'then
db_exp.execute "INSERT INTO tablename " _
& "(fields list[,])" _
& " VALUES(" & m_str & ");"
'close database
db_exp.close酷吧,还有E文解释,因为过几天要进行四级考试,所以练练。
给分吧?