Automatically importing data from Excel to Access (1 Viewer)

deepakpar

New member
Local time
Today, 02:12
Joined
Apr 5, 2010
Messages
2
Hi,

I am a beginner in VB and I'm trying to automatically update a single Access database from a number of Excel files (with different names). Is there any easy way to do this?

thanks!
 

Vassago

Former Staff Turned AWF Retiree
Local time
Today, 05:12
Joined
Dec 26, 2002
Messages
4,751
Hi,

I am a beginner in VB and I'm trying to automatically update a single Access database from a number of Excel files (with different names). Is there any easy way to do this?

thanks!

Will these names or directory structure change? Linked tables might help you out. Otherwise, you'll have to have a certain way to specify what these tables are, either with a dialog box or something a user can fill in.
 

deepakpar

New member
Local time
Today, 02:12
Joined
Apr 5, 2010
Messages
2
Hi,

The Excel file name will change, but the column names and the directory structure will remain the same. I can import the data by specifying each Excel file name but I have hundreds of that so I wanted to know if there is a shortcut (extreme layman terms, something like linking an entire folder of the excel files, so the database will insert data from the new excel files which are added into the folder, into the database)
 

Users who are viewing this thread

Top Bottom