Selective Import

[DanAuber]

I'm importing data from a flat-file - There are several million records in the file - but I only want to import those where the first field is '2001' - is there anyway to do this using the import/transfer text routine ?

I know I could bring all the records in and then delete the one's I don't need - but this leads to database size issues.

Any help gratefully recieved

thanks

Dan

 

[JerryKlmns]

Link the file once and use an apropriate append query. If the file name changes, then write some code that finds and renames the file, overwritting the previous version of it!

 

[MakeItSo]

Several million records?
Wow!

Of course you could write some VBA code that will scan through the file and "import" only wanted records.
That however depends on your file structure.

Google for "FileSystemObject" object, "OpenAsTextStream" and "ReadLine" methods.
Then wrap the read lines into a Recordset-Update block loop.

Hope this helps!

MiS

[navy]"We had to turn off that service to comply with the CDA Bill."[/navy]
- The Bastard Operator From Hell