Importing Text Files - Automating the Task

[ranz]

Hi all,
I have a three level tiered request. Importing of text files into a database, sorting the text so that it understands the rows and columns, and automating this task so that no human intervention is required in future.
I believe that this shouldn't be too much of a problem - there's got to be someone out there that's done it.

First - importing the text file. I need to (unhappily) use MSAccess as my target DB. The text file will be named the same each time - there are three files each requiring different tables to be stored in. An example of the text file is:

,,"S15158 ","Rexel Australia ",11/04/01 0:00:00,,14.00,"8-13 GLAND ",78.15,11/04/01 0:00:00
,"S15158 ","S15158 ","Rexel Australia ",11/04/01 0:00:00,,4.00,"TYPE B BOASS ADAPTOR ",18.70,11/04/01 0:00:00

Tier 2: Text file has grouping required. You can see that sometimes column 1 has a value and column 1 doesn't. I need to group the information by Column 1. I need to make this sort the text before it adds it to the database.

Tier 2a: Footnote: is it possible to get the database to check if the record already exists? If it does - to overwrite it?

Tier 3: Automate the task - preferably in a VB Module - so that I can put it into MSAccess (Yuk).

Your help (as always) is mostly appreciated!

Ranz

 

[tlbroadbent]

Ranz,

Your post may get better response in the Microsoft: Access - General Discussion forum. When you post there, you might explain how you propose to group by column 1 when some rows don't have a value for column 1. Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin