![]() ![]() I had a column containing two types of values: numeric and numeric with a dash. The answer to your question might involve the HOW data is stored in Excel. I’m mainly using an XLS document and the 32-bit import wizard on a 64-bit system, but I’m willing to try anything.Īny ideas of why there are two spreadsheets (sometimes) and why this import would fail? This time there is only one spreadsheet to select. I had this happen once before and I noticed that there were two spreadsheets to choose from during the import process: DataImport and DataImport$ - and the first one would fail as described above and the second one would import flawlessly. I can’t find a pattern for what’s happening. I’ll get all of the first and last names, and some of the ID numbers. It seems to happen most with numbers – so let’s say I have three columns for first name, last name, and ID number. There are no errors and the import process finishes – it just inserts a bunch of null values into the table. ![]() When I use the import wizard to import the data, I can see the columns and the preview data, but the data doesn’t all get transferred over when the import is executed. I can see the data in the columns and everything looks good. I have an excel workbook containing one spreadsheet. The short of it is that I can see the data in Excel, but all of the data doesn’t import. I have an odd thing happening with importing data from Excel to SQL Server using the Import and Export Data tool. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |