Importing excel data to SQL 2005 TABLE

  • 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.

  • Resolved.

    I have combined the date and time columns data in excel itself to new column and imported to sql table.

  • 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