CityofDelrayBeach
asked on
Import and Export Wizard Warnings (SQL 2008 R2)
I am trying to export from a SQL database to Excel format using the Wizard. I put my query in and then I get the "Review Data Type Mapping" screen which has a bunch of Yellow Exclamation Points (WARNINGS). See attached document.
I don't know what to do to fix these or why I'm getting them. Can anyone help?
DataTypeMapping.gif
I don't know what to do to fix these or why I'm getting them. Can anyone help?
DataTypeMapping.gif
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
do you see all the data that you were trying to import in your table?
ASKER
It's actually an export to an Excel file. I'm trying to check with the vendor if all the data is there, but I was just concerned with all those Warnings. So should I just ignore them?
Oh..ok
that shouldn't be a problem then but i would suggest using a csv rather than excel
that shouldn't be a problem then but i would suggest using a csv rather than excel
ASKER
Thanks Danny! I am using the Excel format and just ignoring the Warnings and all the data is coming through!
ASKER
Attached are the Result screen and the Warning Message.
Export-Result-Screen.jpg
Warning-Messages.jpg