import access to excel template


G

Glenn

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?
 
Ad

Advertisements

B

Bob I

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.
 
G

Glenn

I have 65 entries on a form in access. When i query the data to excel,
Everything gets converted properly but i need the data to be transfered to 1
worksheet per entry (or something else feasable) of the access form and
remain somewhat how it looks like it does in form view of access. Right now
it converts everything to look like the datasheet view in access.
Everything is in columns rather than rows listed under the sheet name. Would
it be easier to leave it in that format in excel and use it as a data page,
and use another worksheet to query that data into a form off a table of
contents or am I trying to exceed what excel is designed for? The problem is
alot of our test sheets are done in Excel and it would be easier to hyperlink
everything onto the test sheets and be able to print everything at once, and
not have to hunt thru multiple programs and formats.
 
Ad

Advertisements

G

Glenn

If i goto Forms in excel. Its exactly the way i want it. I can edit it and
what not. The lines are lines and not colums. How do i view and print
those specific forms in excel?
 

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

Top