Import Data from Spreadsheet

[molsen]

Hi All

I have a database, in which I have three tables which hold 'static data', which will be used over and over again to record work and produce invoices.

The Tables are as follows:

tblManagedUnit
MUID (Key) (One to Many with CircuitName below)
MU Number

tblCircuitName
CircuitNameID (One to Many with SpanDetails below)
MUID (FK) (From tblManagedUnit)
Circuit Name

tblSpanDetails
SpanDetailID
CircuitNameID (FK) (from tblCircuitName)
Span From
Span To

I have created the Managed Unit Data manually, of which there are 43. However I have a spreadsheet with 8,600 lines of repeating data in all three categories.

Can anyone suggest the best way of going about importing them with a query? I cant get my head around it!

Any help would be much appreciated

 

[billmeye]

If your just doing it one time, you can copy and paste. If over and over, you can create a link to the spreadsheet and use an append query.