I am trying to find the best way to automate getting an Excel sheet or CSV into Access or SQL Server 2012. The issue I have is that the file has more than 255 columns and thus if I do a basic import, it will only get the first 255 columns. I am just trying to get a process down. Ideally, I would want to have the data go straight into SQL Server 2012, but I am open to any workarounds. I am looking for some guidance and hope someone can point me in the right direction.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Automating Excel Data Into Database
- Thread starter FBandData
- Start date
Similar threads
- Question
