I'm wanting to import data into a table from the attached text file. I first want to delete all the unrelevent data from this text file though that is every thing up to the "TypeRI" string. Can any body give me some example code to open the text file and then delete every thing up to but not including the said string. Thankyou very much and Happy Christmas.
I've hit on another problem. This text file is encoded using Unicode and if I try and use the
DoCmd.TransferText acImportDelim , "tablename", "Filename",True
command I get an error saying ';The field "some weird character" does not exsist in table. If I open my text file in note pad and resave it as ANSI then it imports ok. How do I go about automatically converting this text file from within access or allow it to be imported as I can't alter my import text file as its generated by a program I have no control over.
I've sorted my unicode import problem.
I've created a specification which I use with the transfertext method so it now imports my text file sucsessfully.
All I need to do now is edit my original text file to delete everything up to TypeRI. Then I need to save it and then I can use the TransferText method to import the data.
When I open the text file in access how do I select every thing up to the TypeRI text and then delete it. Then resave the file. Is this possible.