Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TheHobbit81
Starting Member
1 Post |
 Posted - 2010-10-14 : 06:29:50
|
| Hi AllThis is my first post as a new member of this site.I am trying to import a large .xlsx file into MSQL 2008.It ran fine up until almost the end of the process then fails. I am completely new at this and would really appreciate some help.I have included links to the file I am trying to import "AffiliateFutureSoccer - Condenced - Full.xlsx" BUT as this is a fairly large file with a lot of records I have also included a "...Test.xls" version with only 100 lines. Additionally I have also included ".csv" formats of the same files in case they are needed.Finally, I have included the error report that was generated whilst trying to perform the import. "Report1.txt"I am thinking that there is data that SQL does not like. Can SQL handle the tilde (~) symbol?Thanks in advance,Paulhttp://dl.dropbox.com/u/1412205/AffiliateFutureSoccer%20-%20Condenced%20-%20Full.csvhttp://dl.dropbox.com/u/1412205/AffiliateFutureSoccer%20-%20Condenced%20-%20Full.xlsxhttp://dl.dropbox.com/u/1412205/AffiliateFutureSoccer%20-%20Condenced%20-%20Test.csvhttp://dl.dropbox.com/u/1412205/AffiliateFutureSoccer%20-%20Condenced%20-%20Test.xlsxhttp://dl.dropbox.com/u/1412205/Report1.txt |
|
|
|
|
|
Error Importing from .xlsx file to MSQL 2008