Access World Forums

Access World Forums (https://www.access-programmers.co.uk/forums/index.php)
-   Modules & VBA (https://www.access-programmers.co.uk/forums/forumdisplay.php?f=12)
-   -   Importing excel data - sample database (https://www.access-programmers.co.uk/forums/showthread.php?t=307984)

Access_Help 11-16-2019 09:28 AM

Importing excel data - sample database
 
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 11-16-2019 09:33 AM

Re: Importing excel data - sample database
 
Hi. First place to look is in the "similar threads" list down below.

Access_Help 11-16-2019 10:33 AM

Re: Importing excel data - sample database
 
Neither of the threads below provide the solution to my query.

vba_php 11-16-2019 10:47 AM

Re: Importing excel data - sample database
 
1 Attachment(s)
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.


All times are GMT -8. The time now is 08:52 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World