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.