There are a number of different Excel spreadsheets that I have to automating of sending data to a SQL database. There are a number of others that have to pull data from this.
I thought that keeping all my columns as text type columns and then converting data types from when sending data from Excel or pulling data into Excel.
Would this work? What are the disadvantages/advasntages, especially with dates?