Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem importing data into sql server database
I imported an xl spreadsheet data into sql server database. I notice that
some columns data is NULL even though the data exists in spreadsheet. However, the entire columns isn't null, some columns it converts correctly whereas for others it puts <NULL. I tried converting the column into both text and numeric fields, but I got same results. This is happening for a few columns, some columns have been converted correctly. Any ideas as to why it may be happening? How can I fix this? I need to fix this asap as I have project deadline to meet. If this is not the right group for this question, please let me know. Thank you very much, -Me |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) | |||
External data Macro Problem Excel 97 | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Use SQL statements in Excel VBA to query SQL Server Data Problem | Excel Worksheet Functions |