I've got a spreadsheet with around 900 rows in it. I have it in a linked server in SQL (see code attached). One column is the Service Date. Some values in that column are showing in SQL as null, although they are not. All values are a date (this is Excel 2007 & sql 2008). Originally they were the "*3/14/2001" formatted date, and currently they're the m/d/yyyy custom date. Although the values that work and the values that don't have the same format, I've even tried to copy the format using the format paint brush, to no avail.
I can copy (ctrl-c) from a cell that is not showing as null in SQL and paste (ctrl-v) to a cell that is showing as null in SQL, then type over the correct date, and that does work. However, I've also copied the column to another column, then copied from a "good" cell down the column, overwriting the "bad" cells, and tried a formula that will show the previous date (in cell C4, enter the formula "=D4"), but that does not work either.
I'm hoping to use this coding in many future spreadsheets, not just this one, so I'm hoping for an answer that is not going to be sheet-specific.
Any help would be greatly appreciated, Thanks!
@server = 'SvrExcel',
@srvproduct = 'ACE 12.0',
@provider = 'Microsoft.ACE.OLEDB.12.0',
@datasrc = 'T:\Data_Team\CurrentJobs\ClientData1103\WorkInProgress\MasterFile.xlsx',
@provstr = 'Excel 12.0'
EXEC sp_addlinkedsrvlogin 'SvrExcel', 'false'
SELECT * INTO aaLookups FROM SvrExcel...Lookups$