Linking Excel to Access

[Freerider]

Hi all,

Each row in my spreadsheet contains Customer_Name, Amount, (All months of the year), Last_Done. In the columns for Jan - Dec I enter a date (some months will be left blank).

What I would like to do is link all this data to an Access database.
I want to set up two tables- one for Customers and one for Invoices, then create a relationship so I can view all invoice dates for each customer. (This part I can do - getting the data in is a different matter...) I want the dates in Jan - Dec to appear in the Invoices table, and all the other stuff in the Customers table.

I don't want to have to import/export the data manually from my spreadsheet since it changes daily.

Is there any way to get this to work automatically?

Thanks in advance,
Freerider.

 

[Joe4]

Excel files can be linked quite easily into Access as tables. Just go into the Tables object, right click your mouse, and select Link Tables.

If you want to do any manipulation to the data, or selecting certain fields, or have criteria, simply create queries from these tables to get what you want.

 

[Freerider]

Thanks for the suggestion, but I don't think you understand my problem - maybe I didn't explain it properly.

I'll try to use the HTML Maker utility to show my worksheet...