想用这条语句,把Access文件中sample表里的数据导入到txt文件,但是一直提示From 语句有语法错误。
SELECT * INTO [TEXT;DATABASE=C:/temp].sample.txt FROM tb_sample FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\" LINES TERMINATED BY '\n';但如果这么写:SELECT * INTO [TEXT;DATABASE=C:/temp].sample.txt FROM tb_sample就能正常运行谁能告诉我 到底怎么回事 谢谢
SELECT * INTO [TEXT;DATABASE=C:/temp].sample.txt FROM tb_sample FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\" LINES TERMINATED BY '\n';但如果这么写:SELECT * INTO [TEXT;DATABASE=C:/temp].sample.txt FROM tb_sample就能正常运行谁能告诉我 到底怎么回事 谢谢
但即使我写成这样:SELECT * INTO [TEXT;DATABASE=C:/temp].sample.txt FROM tb_sample FIELDS TERMINATED BY ','
它依然会提示相同的错误啊
是的 提示:From 语句有语法错误
那我如果要在Access里控制数据导出的格式
有木有其它的方法呢?