![]() 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 |