Deleting Text Files Rows from Access

[Guest]

I am trying to delete rows from a text file prior to importing it into an
Access database using a module from within the database.

Can anyone suggest the best way to do this programatically?

 

[Alex Dybenko]

I think you can read your text file using Line input # for example, and then
output it to a new text file using print #. but perhaps would be more easy
to import it first in access and then delete from a table

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[John Nurick]

Hi Marko,

Often it's best to link to the text file and then use an append query
to add the rows you want to our table. E.g. something like this air
code:

DoCmd.TransferText acLink, , "TempTable", "C:\Folder\MyFile.txt"
CurrentDB.Execute "qryAppend", dbFailOnError
DoCmd.DeleteObject acTable, "TempTable"

or (more elegantly IMHO) just use an append query that gets its data
direct from the text file, using syntax like this:

INSERT INTO MyTable SELECT * FROM
[Text;HDR=Yes;Database=C:\MyFolder\;].MyFile#txt
WHERE blah blah;"