import access to excel template
Neither Excel or Access have "pages", Access has records and Excel has
rows. And Access will support many more records than Excel has Rows. You
will need to query your data into the amount of rows that your version
of Excel supports.
Glenn wrote:
I need to import a 65 page access database to an excel file. Its not alot of
information. When i import the file into Excel, the format changes. I would
like to have each page of the database go into excel as one workbook page.
Right now it opens all 65 pages and my lines from the database get made into
colums in excel. I have one sheet, thats 24 pages. Do i have to create a
template to import into? Can i import using access's colum setups?
|