Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Improving speed to Import a text file into Access DB AD
Message
Information générale
Forum:
Visual Basic
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Divers
Thread ID:
00601606
Message ID:
00603767
Vues:
24
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform