Exporting calculated values

S

Susan

How do I set up an Excel worksheet to export calculated values into an Access
database?

Susan
 
G

Gord Dibben

Susan

You do it the other way around.

Open Access and Import from Excel.

The data imported can be linked to update as Excel updates.

See Access Help on "import data"


Gord Dibben MS Excel MVP
 
S

Susan

Do I have to format the cells containing formulas in Excel in order for them
to import correctly into Access.
 

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 off automatic calculation 0
Solved Disk Full error message when exporting PDF 0
Calculate the median value before a specified list 0
VBA Export to PDF 0
VBA Coding Help for Beginner 0
Adding Cost Field to Appointment 0
VBA - exporting serial letters to single documents 0
How to export html text as word document with specific size and orientation 0

Top