linking Excel sheet to access database

Question

Hi All,

I am really new to word of Access, here is what i am trying to do.

i have a master table in access, which is imported from Excel sheet, and its is very huge data for excel to handle, 

I am trying to create a database for my company, what I wanted to do, i get the reports in different excel sheets from various vendors on daily basis, as I said before I have a master sheet which  needs to update from excel on daily basis and run a query to show the required output

How do I do it now.. help me with it,,

Regards

samuel

Answer 1

yes i want history but i need master to keep updating everyday,

below are the files i will be using

COUNTRY	Name of the country
PREFIX	Area code ( primary key, unique ID)
BICS Premium	vendor Name
BICS Wholesale	vendor Name
IBASIS Premium	vendor Name
IBASIS Wholesale	vendor Name
Voxbeam Callcenter	vendor Name
Voxbeam Direct	vendor Name
Voxbeam Premium	vendor Name
Voxbeam Standard	vendor Name
FR International	vendor Name
TWILIO	vendor Name
NEXMO	vendor Name
IDT Gold	vendor Name
IDT Silver	vendor Name
IDT Platinum	vendor Name
IDT Speacial	vendor Name

Answer 2

You listed "files" are those the Excel Files you get? I would have a table like I previously described  with at least:

tblRates

RateID (PK Autonumber)

RateTypeID (FK)

VendorID (FK)

EffDate

Rate

From there you can use a query to get the currently effective rates. You do not need nor want a master table that repeats data stored in your main table.

Answer 3

Country

Prefix (primary key, this field has unique number)

Bics premium

Bics wholesale

Ibasis premium

Ibasis wholesale

Voxbeam Standard

TWILIO

hopefully this answers your questions,