Importing xls file to linked tables

[OM]

I have 3 tables tblFI, tblFIDet, tblMac, in Access 2000

tblFI

fldFIAuto, autonumber,

fldDate, date

…and a few more fields that don’t matter.

tblFIDet

fldFIDetAutoID, autonumber

fldFIAutoID, linked to tblFI.fldFIAutoID

fldMacAutoID, linked to tblMac.fldMacAutoID

fldLitres, number

fldMeter, number

tblMac

fldAutoID, autonumber

fldMacNumber, number

…and a few more fields that don’t matter.

The database gathers fuel consumption figures, and generates reports such as
fuel economy, total km, total litres, etc, for various time periods.

The data comes from several sites, where it is entered in XL spreadsheets,
in a table, 4 columns as below :

Date – Truck Number – Litres – Meter.

How do I go about getting this spreadsheet info into the database. I know
that I could change all the sites to using Access, and have a partial
replica setup (I’m not sure how to do that, but I could work that one out),
but there is a lot (several years) of legacy data in spreadsheets, that
should go into the database.

Thanks for any help

Rob Lepper