Exporting from access 2003 to excel 2003 margins

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

Guest

When exporting from access 2003 to excel 2003 how can I maintain the same
margins in Excel used in Access?
 
Margins in what sense? Tables don't have margins associated with them:
that's a concept from printing (and you shouldn't be printing tables)
 
When I select analyze with Excel it shows the default margins of .75 for
right and left. I am running this with a report. If I run the word option
it brings across the correct margins. I have setup my default template in
Excel to use the margins I need but for some reason when access opens excel
or saves a report to analyze in excel it ignores this opening template. Any
thoughts? Thankyou
 
I don't know for certain, but I suspect that Access is building the
spreadsheet itself, before it even opens Excel, so your default template
isn't be used (just as if I sent you a spreadsheet, it wouldn't be used)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ACCESS TO EXCEL 1
Rounding difference in Access 2003 text exports 2
How can I make Access 2003 work with excel 2007 files? 4
Exporting a table from Access 2003 to Excel 2007 1
Error exporting data from access 2007 to excel 2007 1
Link Access to Excel export back to excel 3
Exporting Access Table to text file 9
Access 2003 db's & problems exporting query to Excel 1

Back
Top