Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-01-2019, 12:51 PM   #1
kolait
Newly Registered User
 
Join Date: Oct 2019
Posts: 46
Thanks: 11
Thanked 0 Times in 0 Posts
kolait is on a distinguished road
excel in access

Hello friends
I want to import the excel file in Access with the browser..Please introduce me the code for the browser key

kolait is offline   Reply With Quote
Old 11-01-2019, 12:59 PM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,504
Thanks: 58
Thanked 1,420 Times in 1,401 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: excel in access

Hi. Take a look at the FileDialog Object
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 11-01-2019, 06:30 PM   #3
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,363
Thanks: 555
Thanked 947 Times in 896 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: excel in access

Quote:
Originally Posted by kolait View Post
Hello friends
I want to import the excel file in Access with the browser..Please introduce me the code for the browser key
If you're importing Excel data into MS Access, then there are few issues you should be aware of, I cover them in my blog here:- https://www.niftyaccess.com/excel-in-access/

__________________
Code:
                 |||||
               @(~‘^‘~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access to Excel to Iphone 6 Plus with Excel and back to Access Mike375 General 21 02-12-2016 08:27 PM
opens an excel file and copies values from access textboxes to excel cells deanvilar Modules & VBA 3 05-27-2013 08:27 AM
appending table in access from excel, excel file name change everyday with date gcgc2000 Queries 1 12-28-2012 04:21 PM
Import Excel workbook into Access table using Excel's format (formulas, values, etc) captdkl02 Modules & VBA 1 12-17-2012 09:03 AM
import multiple excel files with FILTERED Excel spreasheet into an access table WuJu Modules & VBA 5 10-31-2011 04:38 PM




All times are GMT -8. The time now is 07:34 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


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