Importing excel data - sample database (1 Viewer)

Access_Help

Registered User
Joined
Feb 12, 2005
Messages
121
Hi,

I really need a simple sample database which demonstrates how to select a an excel file from a chosen location and transfer the data to the specified table.

Can anyone point one out to me please?\

Many thanks
 

theDBguy

I’m here to help
Joined
Oct 29, 2018
Messages
7,705
Hi. First place to look is in the "similar threads" list down below.
 

Access_Help

Registered User
Joined
Feb 12, 2005
Messages
121
Neither of the threads below provide the solution to my query.
 

vba_php

Custom Title Here
Joined
Oct 6, 2019
Messages
2,052
if you want to import a single XLS file from excel, you can do this through the import wizard in access. or, if you want a coding solution, see this sample - which works on any number of excel files that are selected.
 

Attachments

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom