I am not an expert in MS Access, I have been given a text files basically with over hundred thousand records in it and have been asked to load that text file into the MS access database. As I know MySQL, I uploaded that text file into the MySQL database first using normal Load text file command and it worked as expected. However, when in Access 2003, I go to file menu to Get external data and browse the text file, it just don't do anything after I select the file.
I have tried loading through SQL dump, I created a table, switched to the SQL query but I can not copy paste all of those insert commands in it, as a matter of fact it says value is too big to be entered and I can not paste them one by one as the record number is huge.
Any one help? I will be grateful.
解决方案
It's not clear to me what would cause you to be unable to import the text file directly. You'll have to give more details on what you're attempting in Access and where it's going wrong.
But if you've got the data in MySQL already and want to import from there, create a DSN for your MySQL database, then use IMPORT from ODBC, point to the DSN, and you'll be able to import the table from MySQL into Access. It also works with multiple tables at a time.