Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Improving speed to Import a text file into Access DB AD
Message
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00601606
Message ID:
00603767
Views:
25
The file MSADOX.DLL is used for Microsoft ADO Ext. 2.6 for DDL & Security and should be present in \Program Files\Common Files\System\ADO with most VB installations. I create Access databases from VB so I believe that this is the reason I have that DLL included in my VB projects whenever I perform text file imports. Unless you plan to the do same, it should be no problem to exclude this DLL. You might consider reinstalling MDAC 2.6.

The client PC does not have to have Access installed; however, the client PC should have the MDAC 2.6 installed on it.

Since the import file's first row contains the field names for the resultant Access table, specifying only 1 field name on this row may import all data into a single field. However, I have never performed this method myself.
Another method would be to use:

SELECT (FieldName) INTO ... instead of SELECT * INTO ...

where (FieldName) is the desired field name for the data. Again, I have not tried this method myself.

If neither of these methods work for you let me know and I will allocate some time to work out a solution for you.
Karriem A. Shabazz
4MF Software Solutions
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform