Solved Port Data from a local table to a backend table (1 Viewer)

[Number11]

So i have a database that creates a new local table which is created using a week number like

LocalTable_Week1

I need to get access to have a query/vbs to then move the database from the local table to the oready created blank table for the same week number like

Master_Records_Week1

what's the best way to go about this pls

 

[June7]

You want to create a table for each week? Why? Probably should be one table. Why would you need to duplicate data between tables?

 

[Number11]

You want to create a table for each week? Why? Probably should be one table. Why would you need to duplicate data between tables?

Becuase the data changes week on week and we never want to over right any data, also the records are very large so separate tables will be best

 

[June7]

Multiple identical structure tables are hardly ever best.

Transferring records should not overwrite any data.

However, can do something like:
CurrentDb.Execute "SELECT Field1, Field2, Field3 INTO tableName IN 'Drive:\file path\name.accdb' FROM tablename"

 

[Number11]

Multiple identical structure tables are hardly ever best.

Transferring records should not overwrite any data.

However, can do something like:
CurrentDb.Execute "SELECT Field1, Field2, Field3 INTO tableName IN 'Drive:\file path\name.accdb' FROM tablename"

Thanks going to add a week No field and use 1 table

 

[Pat Hartman]

Good choice. You'll be happy with that decision