Bringing in info from excel

  • Thread starter Thread starter Teresa Sell
  • Start date Start date
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?
 
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.
 
Back
Top