Printable View
Using VBA in Word97 to code a macro, I am using the DoCmd.TransferText to import a text file into an Access database.
My problem is - when I run the macro again after the first time, the data appends to my existing table, but I want it to overwrite the existing table.
Are there any arguments to the TransferText command that overwrites a table if the same table name is specified?
First use the range.select command of the activedocument within word.
After that you enter your code where the data is transfered.
This would result in:
ActiveDocument.Range.Select
DoCmd.TransferText
And that should be it.
I have managed to export selected text from Word into an Access table, but my problem is everytime I want to do export to the SAME table I want the selected text to OVERWRITE the table and not append the text underneath the existing data.
I hope that is a little clearer. Any suggestions?