Recent content by Patrick McNally

Solved: Step 1: Setup Table Structures TABLE STRUCTURES Table Name 1: Data_in_2_Columns Fiels Numbers Fields Names Data Type Field 1 Tag Text Field 2 Data Text Field 3 ID AutoNumber Table Name 2 Data_in_Database_Columns Fiels Numbers Fields...

Thank you. I will give that a whirl.

There are 15 files a day, most of the files are about 530,000 lines (10,000 real records) but there is usually at least 1 file a day that is > 50,000 records which is produced in a file that that is 2.8 million records... My skills are VBA skills are not strong. I am an expert in Excel, I've...

It looks exactly similar to the sample with the first 2 charachters identifying the field. Then colms 3 through 50 are the actual pieces of data. The sets are 53 line each. I'd like to be able to import and convert, the first instance of 01 indicating record 1, then put that data begenning with...

:confused: I have 2 columns of data, perfectly consistent... The 1st column is like a tag that states this is field 01 = Name , field 02 = Address , field 03 = City , field 04 = ZIP the 2nd column is the data that belongs in that field. Current Data: 01 Patrick 02 Main St 03...