Help needed to import a txt file

[Zaeed]

Hi, i have a txt file that i wish to import, and transfer some of the information to a table.

This is the form that the file comes in

39 55d3aaad(-) OK 3.0 0{0|0} name1
41 dc2c8c55(-) OK 3.0 0{0|0} name2
42 5e1dbb34(-) OK 3.0 0{0|0} name3
43 18d7785f(-) OK 3.0 0{0|0} name4

what i want is the number and the name from this.. ill be building a table that contains 18d7785f and name4 as a record, 5e1dbb34 and name3 as another record.


i've looked on the forum but cant find that much.. can anyone help?

 

[Ron_dK]

You probably need to search for len , mid functions.

Here's a starter :
http://www.access-programmers.co.uk/forums/showthread.php?t=155243&highlight=mid+string

 

[MStef]

Hello Zaeed!
Look at "DemoImportTxtFileA2000.zip" (attachment).
There are "DemoImportTxtFileA2000.mdb" and "TxtFile1".
Put both in the same directory.
In mdb you can see a LINK on "TxtFile1".
Delete this link and make a new link on "TxtFile1" (because a Path name).
In "Link" form choose TEXT FILES in "Files of type" line. Follow wizard.
When you get a LINK on this txt file, Run a "Query1MakeTable", and you'll have a records you wont in Table1.