View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
glenn glenn is offline
external usenet poster
 
Posts: 122
Default import access to excel template

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?