Adding a table to an Access Form or Report

  • Thread starter Thread starter Ed Hawley
  • Start date Start date
E

Ed Hawley

How can I add an Access table to a Form or Report. I need to be able to
export the table to another program. If I export a "manufactured" table
built box by box, it looks good in Access but when I export it to Excell so
that I will be able to copy it and paste it into another program, it goes in
as one very long string in the Excel spreadsheet. Any ideas would be
appreciated. I don't think that Access has any capability to create tables
but if it does, that would probably work.

Thanks!
Ed
 
Access is all about tables. What part of creating a table are you having
trouble with?
 
Thanks Duane, the problem that I am having has to do with a table in an
Access (XP) report. I can produce the table and populate it with the data
easily. The problem is that I need to copy and past the table into another
program. In access, you cannot copy a table from the "Print Preview" screen
for a report. If I export the file off to Excel, so that I can copy the
table, it goes into Excel as a long string in only one box. That is not a
useful result. I thought that if I was able to create an actual Excel table
within Access then it would probably export correctly.

I hope that helps clarify my problem. If there was a way to copy directly
out of Access, that would be ideal but as far as I know, that is not
possible.

Any thoughts will be helpful and thanks for the help!

Ed
 
Back
Top