B
Bob H
I have a excel spreadsheet at work for shipments comming in to the
country for us, and then delivered by a transport company to a said
power station.
Among some of the 17 column headers, there are:
Customer
Project
Ship from
Ship to
Ship date
Customs in date
Customs clearance date
Delivery date
Commercial Value
The other column headers are dates of receipt of POD, who signed etc,
and hyperlink cells to documents for the said shipment.
I want to put all thisinformation into a Access 2007 database and have
had sometought on how to do it, with separtate tables for CustomerID,
ProjectID, ShipFrom, ShipTo.
Are, or do I need any more separate tables for this database?
Thanks
country for us, and then delivered by a transport company to a said
power station.
Among some of the 17 column headers, there are:
Customer
Project
Ship from
Ship to
Ship date
Customs in date
Customs clearance date
Delivery date
Commercial Value
The other column headers are dates of receipt of POD, who signed etc,
and hyperlink cells to documents for the said shipment.
I want to put all thisinformation into a Access 2007 database and have
had sometought on how to do it, with separtate tables for CustomerID,
ProjectID, ShipFrom, ShipTo.
Are, or do I need any more separate tables for this database?
Thanks