Hello,
about to import from CSV to Ms Access .mdb file and below command does work from Ms Access native Query builder, BUT doesn't work when executed from Java code:
INSERT INTO sample SELECT * FROM [Text;FMT=Delimited;HDR=YES;DATABASE=d:/].[sample.csv]
Getting exception:
java.sql.SQLException: Please assign the operating table name directly
How to import from CSV file via Java code? Do I need to pre-map CSV file, maybe?
Regards
|
|
HXTT Access support select sql into CSV format, but doesn't support import from CSV. If your project need such a feature, we can add it in the near future version.
|
Thanks,
yes, would be convenient to have import from CSV feature
Regards
|
Main
webmaster@hxtt.com