Hi,
I am looking for importing multiple excel file into MS Access all at once. Can anyone help me with this?
Note: Each excel file contains different field names.
Thanks,
Mohan
Hi,
I am looking for importing multiple excel file into MS Access all at once. Can anyone help me with this?
Note: Each excel file contains different field names.
Thanks,
Mohan
Sounds difficult with differing field names, i'd recommend building a massive work book off them all,
so in WORKBOOK1
Field 1 Field 2
a 99
b 100
and in WORKBOOK2
Field 3 Field 4
c 1
d 2
then build these together, and then import
Field 1 Field 2 Field 3 Field 4
a 99
b 100
C 1
D 2
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks