Post reply

Import from excel

  • May 23, 2011 at 9:16 am

    #250691

    Hi,

    I am trying to import some data from excel.

    Some columns (when they are not number) are not imported.

    Can someone help?

    I am using the import data wizard.

    Thank you

  • May 23, 2011 at 9:39 am

    #1328525

    do u see the colum and data when u click on

    edit mappings/preview in the import tasks?

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • May 23, 2011 at 9:41 am

    #1328528

    i see the column but no data.

    I can only see some of the data,...

  • May 23, 2011 at 9:46 am

    #1328530

    check out the datatype if it allows

    all the data to copy...

    Regards
    Sushant Kumar
    MCTS,MCP

  • May 23, 2011 at 9:46 am

    #1328534

    also the length of the data type allowed

    Regards
    Sushant Kumar
    MCTS,MCP

  • May 23, 2011 at 9:51 am

    #1328536

    all columns are varchar.... with a great size...

  • May 23, 2011 at 10:00 am

    #1328543

    huh..okk..

    Tell me wat is hte extension of ur excel file (.xls/.xlsx) and

    also the no of rows in excel file ?

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • May 23, 2011 at 10:06 am

    #1328551

    XLS

  • May 23, 2011 at 10:07 am

    #1328552

    186 rows inside the file on sheet1

  • May 23, 2011 at 10:08 am

    #1328555

    Sample of data of one of the columns:

    866030 - data imported

    866020- data imported

    866030- data imported

    866010- data imported

    866030- data imported

    863040-- data imported

    852206-- data imported

    852206 - data imported

    06206 - data not imported

    851900- data not imported

    851224 - data not imported

  • May 23, 2011 at 10:11 am

    #1328559

    try the openrowset function

    for example :_

    SELECT * INTO dbname.dbo.tablename

    FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\filename.xls', 'SELECT * FROM [sheet name$]')

    Change the location as applicable... its on C drive here..

    Regards
    Sushant Kumar
    MCTS,MCP

  • May 23, 2011 at 10:15 am

    #1328562

    Same problem...

    Most of the data is inserted as null....

  • May 23, 2011 at 10:34 am

    #1328579

    change the datatype to nvarchar and then try again

    and also try changing the file to csv and then try

    bcp command

    Regards
    Sushant Kumar
    MCTS,MCP

  • May 23, 2011 at 10:51 am

    #1328590

    same problem.

    I can send you the file, if you want . It only as 186 rows

  • May 23, 2011 at 10:54 am

    #1328592

    yes send me.

    attach here as a post

    Regards
    Sushant Kumar
    MCTS,MCP

Viewing 15 posts - 1 through 15 (of 17 total)

You must be logged in to reply to this topic. Login to reply