HOW TO IMPORT A TAB DELIMITED TEXT FILE INTO AN ACCESS DATABSE PROGRAMMATICALLY?

[vcseeker]

Hi , I am searching for a good sample code or article that takes a tab delimited file as input and imports it prograamatically in an access database.I don't want to loop through all the records in the text file and then put them individually into access.I want to import the whole file programmatically into an MS ACCESS table.May be it requires OLE. Any help will be appriciated. Thanks and regards.

[Mil10]

Hi, BUlk insertion is not possible in MS Access, but u can do it in Sql Server, just chk out the documentation of BULK INSERT in MSDN, and use _ConnectionPtr to connect to datasource using ADO. best wishes..mil10