Hi,
I have finally completed my database and the tables are completely normalised.
The task I have now is that all of my data is contained within an excel spreadsheet and of course the columns in the spreadsheet relate to various tables that are linked.
What would be the vest method for import?
I have finally completed my database and the tables are completely normalised.
The task I have now is that all of my data is contained within an excel spreadsheet and of course the columns in the spreadsheet relate to various tables that are linked.
What would be the vest method for import?
Hmmm, you could bring in the Excel spreadsheet to a seperate table and then run a bunch of APPEND queries. Not sure there is another way.
