Fast way to import i 
Author Message
 Fast way to import i

 -=> Quoting Scott E. Steeves to All <=-

 SES> I had to write a small program that would take a text file and
 SES> convert it to an Access database.  The program creates a new database,
 SES> then Line Inputs the text file, adding the data to the Access database
 SES> along the way.
 SES> Is there a faster way to import a text file?  Do VB have some sort
 SES> of import function that I don't know about?  Even the VB Knowledge Base
 SES> tells you to do it this way.

 SES> All in all, 8 seconds vs. 8 minutes is ridiulous.  

 SES> -!- FIDOGATE 3.9.1
 SES>  ! Origin: Fido.DE domain gateway (242:4900/99.0)

Hello Scott,
I don't know how to invoke this from VB, but in ACCESS BASIC there is a
faster way.
First, you create an import specification in ACCESS. This is a definition,
what field uses which bytes of an import record.
Then you call a function:

   DoCmd TransferText A_IMPORTFIXED, strImportSpec, strTable, strFile

where A_IMPORTFIXED is a keyword for fixed length
      strImportSpec is the name of your specification
      strTable is the name of your table
      strFile is the name of the file with the data you want to import

Hope this is of any use for you...


... Take my advice, I don't use it anyway.
___ Blue Wave/QWK v2.12

Sat, 18 Oct 1997 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. Any ways to get MDX faster?

2. Fast ways for inserting images

3. Fastest Method of Importing to Access 2.0 DB

4. Importing Flat File into 113 tables Fast?

5. DB cannot grow fast enough during DTS import

6. SQL2k - Fastest file import methods?

7. How to Import records in Sql Server FAST

8. Need Help Fast: Can't Import Oracle Export direct option set to Y

9. Fast way to import into a database

10. faster import in v.7.1 than in v.7.3

11. Faster way to import CSV files

12. Fast/easy way to import MS-access database to MSSQL6.5

Powered by phpBB® Forum Software