Bringing in info from excel

T

Teresa Sell

I'd like to bring in dollar amounts from a SBC
application and bring into Access database that indicates
accounting unit, billing ID. There are 600 records per
month. How do I best do this?
 
J

John Nurick

Hi Teresa,

The general idea is first to link or import (File|Get External Data) the
Excel sheet, and then use an append query to select the data you want
and add it to the relevant table in your Access database.

Post back here with more information if you need a more specific answer.
 

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

Check boxes 1
Integrating information from Word to Excel (not mail merge) 1
Merging from an Excel file with graphics 1
Client Access File Transfer from Excel 2010 3
Bringing a chart web part into an Access 2010 web db 0
Exporting to Excel 0
Using Microsoft Access as a Service Ticket Write-up program 0
Importing from Data Acquisition System ??? 3

Top