Hi all im designing my first ever database, and would like to know the best way to import data from excel which isnt normalised. below are the headings in excel and also what time of information which would be in each column, this report comes from Esso every month, so i dont really want to play with the orginal format, id like Access to do all of that for me.
Account No Always the same 7 digit number
Date Drawn Time and date of the purchase
Card # A 3 digit number assigned to the tech so this would be repeated data
Site Name Abbreviated name of a petrol station this could be any garage in the uk
Transaction # A unique 12 digit number
Reg at Site Van Registration number, the same reg will be on here multiple times
Reg on Card Also left blank
Driver on Card Name of the Driver so more repeated data
Odometer the milege of the van this is sometimes blank
Product two options DERV (diesel) or LUBE (Oil)
Qty How many litres
Inv Price Cost per Unit
Cost of Sale Total cost as a currency
Inv Date im invoiced twice a month so this would be a date either the 15th of the month or the 28th of the month
Inv Number Again twice a month all the records are attached to an invoice number so this is recurring data
Bunker Diesel Always shows as FALSE
Est Price The same as the Cost per unit
Cost Centre Always Blank
Driver Description Always Blank
Please can anyone point me in the right direction with how to do this, ive been reading up about importing it all into a tempory table then using sql to move the information to proper tables?? but i wouldnt know where to start with this???
Account No Always the same 7 digit number
Date Drawn Time and date of the purchase
Card # A 3 digit number assigned to the tech so this would be repeated data
Site Name Abbreviated name of a petrol station this could be any garage in the uk
Transaction # A unique 12 digit number
Reg at Site Van Registration number, the same reg will be on here multiple times
Reg on Card Also left blank
Driver on Card Name of the Driver so more repeated data
Odometer the milege of the van this is sometimes blank
Product two options DERV (diesel) or LUBE (Oil)
Qty How many litres
Inv Price Cost per Unit
Cost of Sale Total cost as a currency
Inv Date im invoiced twice a month so this would be a date either the 15th of the month or the 28th of the month
Inv Number Again twice a month all the records are attached to an invoice number so this is recurring data
Bunker Diesel Always shows as FALSE
Est Price The same as the Cost per unit
Cost Centre Always Blank
Driver Description Always Blank
Please can anyone point me in the right direction with how to do this, ive been reading up about importing it all into a tempory table then using sql to move the information to proper tables?? but i wouldnt know where to start with this???
