Help please with importing data from xls.

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

re: Help please with importing data from xls.

"OM" <lepperrj@loxinfo.dot.co.th> wrote in message
news:c8id67$d8g$1@news.loxinfo.co.th...[color=blue]
> 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[/color]
as[color=blue]
> 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[/color]
out),[color=blue]
> but there is a lot (several years) of legacy data in spreadsheets, that
> should go into the database.
>
>
>
> Thanks for any help
>
>
>
> Rob Lepper
>
>[/color]

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.

re: Help please with importing data from xls.

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