June 28, 2007 at 8:53 am
It wasn't too hard to get the spreadsheet imported. The problem I have is users that change the name of the sheet periodically.
Importing when the sheet name is known is easy, but how do you import a spreadsheet when the sheet name is unknown.
there is always only one sheet, so a routine that walked thru all the sheets would do the trick too?? I just can't find any information about how to do it.
Thanks
Chuck Snyder
June 29, 2007 at 7:09 am
Haven't tried this with SQL Server, but this works with Access:
I import from a workbook that has one sheet of data, but it also might have a sheet of instructions. (The file is an export from QuickBooks.)
As long as the data is in the first sheet of the workbook, I can tell Access to import from Sheet1 and it works, regardless of what the actual sheet name is.
July 2, 2007 at 5:30 am
In the sheet that the users are using write a macro that on close copys the sheet to another spreadsheet that has a consistent name and is in a consistent location. The SSIS package can then be pointed at this consistent spreadsheet.
Failing that shoot the user !!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply