Importing only part of file.

[VoIPgirl]

I have a csv file that is very large that the import process takes too long. I only need to use some of the data. Is there a way to specify what I would like to import?
Thanks for your help.

 

[jbpez]

Look at this,

DoCmd.TransferSpreadsheet acImport, 8, "TableName", "C:\...", True, "A3:H500"
DoCmd.TransferText acImportDelim, "", "TableName", "C:\...", True, "A3:H500"

The last argument you can specify what columns to import.

John Borges

 

[VoIPgirl]

Thanks. What if I want to import all columns, but not all records?

 

[jbpez]

The last argument the letters refer to columns: column 1 = A, column 2 = B ..., then the numbers refer to the rows.

So, if you want import say, column 2,3 and 4 from rows 100 to 200 then you would write B100200.

I hope this helps

John Borges