By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,398 Members | 933 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,398 IT Pros & Developers. It's quick & easy.

Importing xls file to linked tables

P: n/a
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
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.