Hi DB,
Thanks so much for this, reassures me that in principle this is do-able.
Sadly your response is way above my understanding!
I'll see what I can do!
Ta
Tim
Hi,
it does help in as much as the principle, no idea how do create the Loop or the stringset!
Know any tutorials that could point me in the right direction?
Really appreciate your help, thank you
Tim
Sorry for the poor choice of phrase.
It's the second scenario, dynamic column names
The data sheet can have a max of 38 columns, sometimes it might only have 6, or any number in between.
Does that clarify?
Cheers
Thanks DB.
I kinda get the idea of importing to a temp table so that all the data is then in access....but what's the next step?
Again, I get the principle of selecting data if it's there but how do I work around the null values?
Is there any examples you're aware of that I could be looking...
Hi,
I download a report weekly for a 10 clients, my aim is to create a mast table with all the data for all the clients to allow me to analyse and create summary reports. (the data is a CSV but I've been saving it to a XLSX)
In my basic world I created a series of import steps to create a...
Hi all,
Basic level access user here (UK) with a specific problem I need to solve with importing excel data, I'll post in the Excel thread.
Many thanks
Tim