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

Help please with importing data from xls.

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
Share on Google+
2 Replies


P: n/a

"OM" <le******@loxinfo.dot.co.th> wrote in message
news:c8**********@news.loxinfo.co.th...
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


I am not sure how far along you are but I would use the
DoCmd.TransferSpreadsheet acImport command behind a button on a form
it will let you import an xls spreadsheet into access.

then from there use your sql statements to create, update, append your
tables

Sorry this is very general.



Nov 12 '05 #2

P: n/a
The first thing that came to my mind, is linking the excel sheets to
the dbase and using that data as a table. To do that, you need to go
into access and in the tables menu, just right click and select link
tables.... then find the spreadsheet and go from there.

Or you can just copy and paste into a dbase, but that might take some
time. If you need more help just email me back.

Paul
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.