Importing to Excel in defined cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have a template spreadsheet in excel that I want users to complete, I
have managed to import from the spreadsheet into Access which is great, but
now I need to understand how I can export my query into excel but I need
specific fields to be imported on to specific cells.

example in my query I have
Reference No. this needs to go into cell E6
Name this needs to go into cell E8
Address this needs to go into cell E9 and so on. How is this possible to be
done from the click of a command button on a form?

Thanks for any help, Jez
 
Hi, I have a template spreadsheet in excel that I want users to complete, I
have managed to import from the spreadsheet into Access which is great, but
now I need to understand how I can export my query into excel but I need
specific fields to be imported on to specific cells.

example in my query I have
Reference No. this needs to go into cell E6
Name this needs to go into cell E8
Address this needs to go into cell E9 and so on. How is this possible to be
done from the click of a command button on a form?

Thanks for any help, Jez
Click to expand...

Read the Excel stuff at www.mvps.org/access in the modules section.
 
Back
Top