April 29, 2010 at 8:22 am
Hi All,
I have a spreadsheet i would like to load to a sql server table but its not a straight forward spreadsheet.
What i want to do is to automate the process so that if the user uploads the spreadsheet to a folder i'll grab it once a day and
load the file to sql server
Basically looks something like this:
Phone 1
sagem1 nokia1 htc3
sagem1 nokia1 htc3
sagem1 nokia1 htc3
Phone 2
sagem12 nokia12 htc32
sagem12 nokia12 htc32
sagem12 nokia12 htc32
the cells and rows could differ
How can i grab the heading phone1,phone2 has table names and then load each child rows to the corresponding tables
or maybe have
Phone 1 sagem1 nokia1 htc3
Phone 1 sagem1 nokia1 htc3
Phone 1 sagem1 nokia1 htc3
Any ideas??
Thanks in advance
April 29, 2010 at 8:36 am
Hi,
The link below should help you to get the list and you can then store it a variable, use it in an Expression in Derived column to add the table name to the rows. But, if the Columns in table differ then it gets a little tricky, probably you will need some more scripting to check each column and then load it into your table.let me know, if this helps or we can find an alternative
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply