Excel Reports Using Access

[Jon E]

I would like to use Microsoft Access to store Data, and then use Excel to
produce the reports using the data stored in one Access Table. The data is
already in an excel table, but i would like to transfer it to an Access
table. I tried to import the table into Access but this resulted in an
error. Any suggesstions?

Also, once i get this data into Access, what are some ways to produce
reports in excel using the access data?

Any help would be much appreciate!

Thanks

-Jon

 

[Mike Painter]

I would like to use Microsoft Access to store Data, and then use
Excel to produce the reports using the data stored in one Access
Table. The data is already in an excel table, but i would like to
transfer it to an Access table. I tried to import the table into
Access but this resulted in an error. Any suggesstions?

Without knowing what the error was there is not much we can do.

Also, once i get this data into Access, what are some ways to produce
reports in excel using the access data?

Export the tables back out, however the reports that can be generated by
Access are far more powerful than what you can do in Excel.

 

[MarkD]

You can do this, but it takes some (lotsa) VBA coding
depeinding on what you want to do.

Look at this page
http://www.mvps.org/access/modules/mdl0006.htm

it gives you an idea of what it takes. I've created a few
Excel Reports using Acces data. Takes trial and error, but
you can do some cool stuff.

-Mark

-----Original Message-----
I would like to use Microsoft Access to store Data, and then use Excel to
produce the reports using the data stored in one Access

Table.