Post reply

Load data from excel sheet to table

  • February 14, 2012 at 6:19 am

    #1446803

    Jeff Moden (2/5/2012)

    As a sidebar, I generally don't import directly from Excel spreadsheets because you can't tell when someone might have it open. I usually tell people to do an export from the spreadsheet to a TAB delimited file.

    Most of the Excel sheets we get are dumped in a restricted server folder where the BU can't access them, so I don't have that excuse. And many of these are auto-generated by third party vendors that only do their data exports "one way." @=Pbt

    Feel sorry for me, please. I could use a little sympathy (and some cookies, chocolate chip if you've got 'em.)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • February 14, 2012 at 6:30 am

    #1446814

    I have a situation where I can only run scripts in the server.

    So, to import data from excel I just write insert statemens using the concatenation function from excel.

    =CONCATENAR(",(";A2;",'";B2;"','";C2;"','";D2;"','";E2;"','";F2;"','";G2;"','";H2;"','";I2;"','";J2;"','";K2;"','";L2;"','";M2;"','";N2;"');'")

    It ill fil a stag table where I can clean and format the data before updating the production tables.

    It's a easy and safe mode to import small chunks of data when you are not allowed to data bump.

Viewing 2 posts - 16 through 17 (of 17 total)

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