import text file to Access database

G

Guest

I have a delimited file w/o column headers organized as follows:

123456789 2006/10/16 09:37 PtSSN 123-45-6789
123456789 2006/10/16 09:37 PtAge 61
123456789 2006/10/16 09:37 PtDOB 01/01/1990
123456789 2006/10/16 09:37 PtSex M
123456789 2006/10/16 09:37 PtName SMITH, JOHN
987654321 2006/10/16 09:37 PtSSN 987-65-4321
987654321 2006/10/16 09:37 PtAge 53
987654321 2006/10/16 09:37 PtDOB 02/01/1990
987654321 2006/10/16 09:37 PtSex F
987654321 2006/10/16 09:37 PtName SMITH, JANE

where the first column of data is a unique id from a demographics table in
the exporting application, the second column is the date the data was
entered, the third column is the time entered, the fourt column is the field
id, and the fifth column is the actual data entered.

How do I import this into an Access data table?

P. S. I am used to using files that look more like this:
123456789 2006/10/16 09:37 123-45-6789 61 01/01/1990 M SMITH,JOHN
987654321 2006/10/16 09:37 987-65-432153 02/01/1990 F SMITH, JANE
 
J

John Nurick

See my answer to your earlier post.

I have a delimited file w/o column headers organized as follows:

123456789 2006/10/16 09:37 PtSSN 123-45-6789
123456789 2006/10/16 09:37 PtAge 61
123456789 2006/10/16 09:37 PtDOB 01/01/1990
123456789 2006/10/16 09:37 PtSex M
123456789 2006/10/16 09:37 PtName SMITH, JOHN
987654321 2006/10/16 09:37 PtSSN 987-65-4321
987654321 2006/10/16 09:37 PtAge 53
987654321 2006/10/16 09:37 PtDOB 02/01/1990
987654321 2006/10/16 09:37 PtSex F
987654321 2006/10/16 09:37 PtName SMITH, JANE

where the first column of data is a unique id from a demographics table in
the exporting application, the second column is the date the data was
entered, the third column is the time entered, the fourt column is the field
id, and the fifth column is the actual data entered.

How do I import this into an Access data table?

P. S. I am used to using files that look more like this:
123456789 2006/10/16 09:37 123-45-6789 61 01/01/1990 M SMITH,JOHN
987654321 2006/10/16 09:37 987-65-432153 02/01/1990 F SMITH, JANE
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

novice question - import text file w field ids on each row to Acce 1
How to get the array like this? 6
Import a text file to acces using VB 1
Remove lines from text file prior to importing in Excel 3
Data from Access database needed in Excel spreadsheet...how to do it? 4
Access denied while adding a NamedProperty 0
Total Summed Count of Numeric Repeat (Paired /Double Instance) Criteria 2
who can help please with table query ? 1

Top