Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Some Excel dates can't be imported into sql server?
I have a spreadsheet that I tried to import into sql server. Some
columns have dates in them. I find that some columns do appear in the resulting database table with their dates. But in one column of the database table, the dates are converted to blanks. I looked at that column in the spreadsheet, and I tried formatting it differently, but that didn't help. I thought that maybe the column had text fields that looked like dates, but that doesn't seem to be it either. The resulting database table looks odd because the dates from this column don't become NULLs, instead they become blank strings. Usually a blank cell in a spreadsheet translates to a NULL in the database table, but when these dates are present in the spreadsheet, they translate to a string of zero or more blanks. If anyone has run into this before, and solved it, let me know. Thanks, Marv |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Some Excel dates can't be imported into sql server?
Is it possible that the dates that aren't imported are text. In an adjacent
column put this =ISTEXT(A1). (or whatever the cell address is) -- HTH, Barb Reinhardt " wrote: I have a spreadsheet that I tried to import into sql server. Some columns have dates in them. I find that some columns do appear in the resulting database table with their dates. But in one column of the database table, the dates are converted to blanks. I looked at that column in the spreadsheet, and I tried formatting it differently, but that didn't help. I thought that maybe the column had text fields that looked like dates, but that doesn't seem to be it either. The resulting database table looks odd because the dates from this column don't become NULLs, instead they become blank strings. Usually a blank cell in a spreadsheet translates to a NULL in the database table, but when these dates are present in the spreadsheet, they translate to a string of zero or more blanks. If anyone has run into this before, and solved it, let me know. Thanks, Marv |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing 2 extra spaces in front of dates in imported excel doc | Excel Discussion (Misc queries) | |||
How to prevent Excel converting imported fractions into dates | Excel Discussion (Misc queries) | |||
Excel 2003 Trashes Imported Dates | Excel Discussion (Misc queries) | |||
Excel 2003 Mis-Translates Imported DD/MM/YYYY Dates | Excel Discussion (Misc queries) | |||
Ensure dates imported into Excel 2003 are shown in DD/MM/YYY form. | Excel Discussion (Misc queries) |