jumping back and forth from ACCESS to Excel

G

Guest

I am recording time to a table, from a form in ACCESS, and I would like to
calculate inputted data in ACCESS. But due to the type of clacs I am doing I
think I am going to need to export data to excel calculate and then return to
ACCESS to perform reports.

Can I do this?
If I need the prog to do this automatically will I have to use a Macro?
Can I print a report in ACCESS from worksheet results in Excel?
 
J

Joseph Meehan

Jimenda said:
I am recording time to a table, from a form in ACCESS, and I would
like to calculate inputted data in ACCESS. But due to the type of
clacs I am doing I think I am going to need to export data to excel
calculate and then return to ACCESS to perform reports.

Can I do this?
If I need the prog to do this automatically will I have to use a
Macro?
Can I print a report in ACCESS from worksheet results in Excel?
Click to expand...

Maybe you could give us an example of the calculation.
 

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

Similar Threads

Turning a 3 column flat file into a "3D" Table 2
Excel solver via access/vba 1
Using Append to Update & Calculate Data 10
Calculating in Access 2003 like calculations in Excel 2003 5
export to excel and save 4
Import data from Access to Excel containing VB code 3
Help: I want to export data from access to excel and back to acces 2
Opening form and going to a specific field in the middle of the from 1

Top