December 30, 2024 at 9:23 pm
Hi, after i copy in ssis my excel file to a secured folder, its looking more and more like i'll need to get data out of the destination spreadsheet at the cell level.
i'm looking at posts like the one at https://stackoverflow.com/questions/41702840/i-need-to-pull-specific-cells-from-a-single-excel-file-to-create-a-single-row-in but dont believe power query is the answer because 1) its an add in and i'd like to leave the spreadsheets alone, 2) if i were to publish a power query driven item to the pbi service i'd probably have no economical way to get ssis involved and i'd probably be creating a dataset which i believe requires more than the pbi pro licenses we live with today.
on the other hand the poster at that link says he found a way to use vba to extract cell level data. Outside of ssis. Can the community tell me where such vba would run from and how it would be awakened to do this? ive used it before i believe in both ssrs and excel but cant picture how it can be run externally to but using my spreadsheet as a source.
December 30, 2024 at 10:31 pm
Importing data from a specific Excel range is perfectly doable – and that range can be a single cell. No need to resort to PBI or VBA, just a standard data flow.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply