BCP equivalent in MS Acess

[moksha.muser]

Hi Folks!

Need help! Is there a BCP equivalent in access. I want to load 2 million rows into an access database.

Any pointers will be of great help.

Thanks,
Moksha

 

[Pat Hartman]

There is no BCP available. If the data is in a text file with one record per row, you can use the TransferText method/action to import the data. Alternatively, you could link to the source database and import directly from it.