Hello everyone,
The whole access thing is pretty new for me and i will apprecite any help from you.
I have an existing excel data on more then 3600 file who I want to collect to one database.
The file structure is same so it shouldnt be a problem, but I cant do it with the wizard because there are too many files.
I need to select only few column from the excel file and not the whole sheet. I wrote a macro and i tried to fill the range fileld with the right syntex without succes (When I leave the range field empety it works).
lets say i need coulmn a:b & c
how sould i write it.
Thanks a lot