October 25, 2010 at 10:34 am
I am trying to export the excel data to SQL 2005 table using import/export wizard.
excel data
Subject,Date, Time, Value
9410 6/30/2006 8:57:23 141
When I import this data to sql output is
9410(float),2006-06-30 00:00:00.000(datetime), 1899-12-30 08:57:23.000(datetime),141(float)
please let me know the datatype that I need to select while importing.
do I need to combine the date and time columns data in excel before import?
Thx.
October 25, 2010 at 12:53 pm
Resolved.
I have combined the date and time columns data in excel itself to new column and imported to sql table.
October 25, 2010 at 12:58 pm
Hi,
I am trying to export data from Excel 2007 to SQL Server 2005.
excel data
Average,Standard Deviation,t_min_median,t_max_median
74.64%35.72% 22:30:00 3:30:00
64.01%42.84% 23:30:00 11:30:00
48.29%44.00% 0:30:00 17:30:00
when import to sql table data is like below
0.746428571428571,0.35722269960311, 1899-12-30 22:30:00.000,1899-12-30 03:30:00.000
Please advice on datatypes? Is there any datatype for only time in SQL?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply