reimport data woth out deleting the table

[metalman]

is it posible to import data into an access table without deleting the table. i have three tables where the format and properties stay the same but when i update the tables it reforamts the table to default setings. this is what 8i am currently useing

Option Compare Database

Private Sub Command0_Click()
DoCmd.DeleteObject acTable, "jrnitm_importerrors"
DoCmd.DeleteObject acTable, "Items"
DoCmd.DeleteObject acTable, "Header"
DoCmd.DeleteObject acTable, "Entry"

DoCmd.TransferText acImportDelim, , "Items", "L:\cw\rpts\JRNITM.TXT", False
DoCmd.TransferText acImportDelim, , "Header", "L:\cw\rpts\JRNHDR.TXT", False
DoCmd.TransferText acImportDelim, , "Entry", "L:\cw\rpts\JRNENT.TXT", False

End Sub

 

[webi2002]

Stick to basics. You only need to delete the contents of the table that you need to import to prior to importing, since Access appends information to tables if they already exists.