Transfer Spreadsheet Question

[AccessIM]

I have been reading through all the posts about using transfer spreadsheet to
append records to an existing table. Is it possible to use this same
function to replace an existing table? If not, what would be the best way to
do this? Currently I am using the File-Get External Data method, naming the
table the same name as the existing table and saying "Yes" to the overwrite
prompt.

Thanks in advance.

 

[Jeff Boyce]

Another approach is to import the data raw, then append the (normalized)
data into your permanent tables.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

Another approach is to import the data raw, then append the (normalized)
data into your permanent tables.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[AccessIM]

Thank you for your fast response, Jeff.

I actually found a way around this by creating a delete query to delete the
data from the table. I then created a macro that first runs the delete query
and then runs the transfer spreadsheet to bring in the new information. This
inserts all the new information into the table and actually works better than
the File-Get External Data because I don't have to go in and change the data
type on one of the fields everytime like I did before.

 

[AccessIM]

Thank you for your fast response, Jeff.

I actually found a way around this by creating a delete query to delete the
data from the table. I then created a macro that first runs the delete query
and then runs the transfer spreadsheet to bring in the new information. This
inserts all the new information into the table and actually works better than
the File-Get External Data because I don't have to go in and change the data
type on one of the fields everytime like I did before.

 

[Jeff Boyce]

I use that same solution frequently (create a table to fill, empty it, then
reload it).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

I use that same solution frequently (create a table to fill, empty it, then
reload it).

Regards

Jeff Boyce
Microsoft Office/Access MVP