HOW TO IMPORT A TAB DELIMITED TEXT FILE INTO AN ACCESS DATABSE PROGRAMMATICALLY?
-
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. :)
-
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. :)
Connecting to the MDB using DAO classes and looping through the records in the CSV file and inserting them isn't that bad an idea. I think ODBC allows a DSN to be associated with a tab delimited file. It might be workable to assign a System DSN to the tab delimited file and then you could use ODBC to move the CSV file to an Access table. I'm going to live forever or die trying!
-
Connecting to the MDB using DAO classes and looping through the records in the CSV file and inserting them isn't that bad an idea. I think ODBC allows a DSN to be associated with a tab delimited file. It might be workable to assign a System DSN to the tab delimited file and then you could use ODBC to move the CSV file to an Access table. I'm going to live forever or die trying!
Or, simply define the text file as an ODBC DSN and create an external Link in acess. Then, you can do a standard insert/select query right in access. onwards and upwards...
-
Or, simply define the text file as an ODBC DSN and create an external Link in acess. Then, you can do a standard insert/select query right in access. onwards and upwards...