Converting large excel spreadsheet to normalized data in SQL 2012

  • vecerda - Thursday, August 7, 2014 10:53 AM

    How would I adjust the code so it works with SQL 2005 database?thanks for all you help,Petr

    If you can use a MS access database, you should be able to map the file to a corresponding MS access database with the same name.  Then, you can copy/update records to another table.  You can map the MS access to a SQL server backend.

    DBASupport

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply