The plan is to 'transfer' from an Excel speradsheet, data into a SQL database.
One thought is of course 'how-to-prep' the database to recieve the content of the spreadsheet if necessary.
This Excel spreadsheet will be 58,000+ lines of data with each line of data containing more than a few 'fields' of information. These seperate fields of data will be in many different combinations of text, numeric values, dates, etc.
Another question will be this 'table data' in the spreadsheet and the transfer into the SQL database, is there any importance as to defining the information in the spreadsheet such as date data (like 01 Jan 2010 as there is many ways to define the date).
A second of many possible questions is this transfer. Can the transfer be direct from the 'open file', connect to the database and then 'make the move'?
No doubt, many 'think about it first' before doing questions could be asked before 'having been there, done that' experience takes over but till then, one step at a time.
View Complete Post