access97 export to excel97 (a97)

Topic

New Reply

hello there
i have a table frm access and i want to export to excel file. The problem is everymonth I need to export this table to excel and instead of replace or overwrite the old records, the next access table will add into next row using the same excel file. How to go about it??pls help…
Thank you
nuglorious

Reply | Quote

Replies

Probably the easiest way is to copy the records in Access, and paste them into Excel below the existing rows. Then delete the superfluous row with field names.

If you want to automate this, it would require familiarity with Access and Excel VBA.

Reply | Quote

Really?..hmm…so this add to the next row needs Excel VBA???…wow…im not familiar with the ExcelVBA….
if thts the case then i have no choice which as u said to use copy and paste.

thank you

Reply | Quote

I’m afraid so. All standard routines to export data from Access or to import data into Excel assume that you want to overwrite the existing data. Copy and paste is your best bet, and since you have to do it only once a month, it is not much work.

Reply | Quote

I’m afraid so. All standard routines to export data from Access or to import data into Excel assume that you want to overwrite the existing data. Copy and paste is your best bet, and since you have to do it only once a month, it is not much work.

Reply | Quote

Really?..hmm…so this add to the next row needs Excel VBA???…wow…im not familiar with the ExcelVBA….
if thts the case then i have no choice which as u said to use copy and paste.

thank you

Reply | Quote

Probably the easiest way is to copy the records in Access, and paste them into Excel below the existing rows. Then delete the superfluous row with field names.

If you want to automate this, it would require familiarity with Access and Excel VBA.

Reply | Quote