Export all Excel sheets in a folder to access master table using V

H

HelpNeeded

Hi,
I have 700 excel sheets in a folder. All excel sheets contains same fields.
I want to move all the sheets to access database. The tables is already
created. I want to move it using VBA. Can someone help me with the code
please?
I also want to add the file name of the sheet to a additional field in the
same table. Please Help... Thanks.
 
D

Doug Robbins - Word MVP

I would suggest that you ask in either microsoft.public.excel.programming or
one of the Access newsgroups. This one is for the use of VBA in Word.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
VBA - exporting serial letters to single documents 0
External cell reference between two excel worksheets both in One Drive 0
Excel - Wich Function should I use? 1
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Delete all data after a symbol in a field 0
VBA Coding Help for Beginner 0
Many sheets, one DB? 1

Top