exporting a table

  • Thread starter Thread starter matt donker via AccessMonster.com
  • Start date Start date
M

matt donker via AccessMonster.com

Hey people

I want to export specific information from an exsisting table i have into a
spreadsheet and then delete it from the table i have in my database.
Basically create an archive record. However every way i have tried resulted
in an table locked error so i will see what you guys can come up with.

Table i want to export from name is tblToolingTracker"
Spreadsheet i want to export to is called a two varialbes MonthName & Year
num

I want to export all fields in tooltracking that match my variable
MonthNum, which contains the number of the previous month.

I used a run SQL statement to delete the records from the old table but if
anyone has a better idea please go ahead and show me.

Thanks people i really need this.

Matt
 
ps the field in toolingtracker that the variable would compare to is Date
 
Back
Top