Search results

i took away the brackets and its works now, lol, thanks alot for all you help.

i set up a specification and use the code below which is attached to a button when clicked. DoCmd.TransferText acImportFixed, "Test", "Aaa", ["C:\aaa.txt"], True But when i click the button there is an error message saying "Access can't find 'l' referred to in your expression". Any ideas? thanks.

Scrap my last post, i experimented abit more with what you said he kinda know what direction im going. Thanks alot.

Yeh, someone showed me that way. But the problem is that by using the access import wizard, each time i import a text file i have to divide the line of text into the fields. Also, i have to use the whole line of text, but i only want certain parts from it. Im trying to make the process as...

hi, im trying to create a database that will store exam results on a database with ready made tables. The problem is that the exam boards send the results in a string of text with the first 5 characters representing the EntryCode and the next 4 representing the ResultsCode etc. I wanted to know...