Delimited Excel Data to Access Table

[DavetheVBNewb]

I would like to write a code that can open text files within a directory and transfer the information into an Access data table.

There is a table setup with records (currently empty except for the file name) for each file.
The key for each Access record is the name of the text file.
There are about 50 text files in the directory. Each contains 10 cells I would like to transfer data from.
The text files are delimited using commas. I’m guessing these would have to be separated first into columns.

Can someone help me?

 

[datAdrenaline]

>> I’m guessing these would have to be separated first into columns. <<

Nope ...

.....

Do your text files have column headers? ... Can you post one of the text files? ... If the text (aka: CSV files) have column headers, do they coresspond with the field names of the destination tables? ... Do you NEED the data in a Table, or if you had a query that READ the text files could you use that? .... I know ... soo many questions, but IMO, there are soo many solutions! ... I will often just use a Query to read a text file as I have no need to change the information in them, I just use them for reporting and such, so there is no need to import... But, I have also had a need to import the data (archival type processes) ...

 

[DavetheVBNewb]

Wow, thanks for the quick response!

The information I'd like to transfer is listed in rows. The names of each row match the fields within the Access table. I've uploaded an example text file "Text File.txt".

Information within the file I'd like to transfer:
Work Order
Operator
Load Case
Condition
Load Cell Number
Blue Box Number
Encoder Number
LVDT 1 Number
LVDT 2 Number
Notes
Date,Time,Specimen


Also, if possible I'd like to record the maximum value listed in the "Load (lb)" column.

I'm guessing it would be better to transfer these to a table because I will need to archive the information, but I'm not sure.

 

[datAdrenaline]

... Sorry about the delayed response!!! .... I probably deleted the notification inadvertently! ... Have you gotten this issue resolved?