Results 1 to 4 of 4
  1. #1
    ijaz8883 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    103

    How to Import Tables in MS Access via VB Code

    Hi
    Let me know How can I open this dialogue box in vb code by clicking on a form button so I my choose the location and file to select the table which I want to import.
    Click image for larger version. 

Name:	how to open in vb.jpg 
Views:	12 
Size:	123.6 KB 
ID:	37419
    Thanks

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you can import XL sheets with:
    docmd.TransferSpreadsheet acImport ,acSpreadsheetTypeExcel12,sTbl, sFile, true,sSheetName

    you can import ODBC tables via other data sources by:
    0.use ODBC to link the table as an external table,(done once)
    1. run an append query to import the data.

  3. #3
    ijaz8883 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    103
    Sorry I have made a Mistacke my circle goes out of range
    I want to import Access Tables not ODBC
    I want a button on Access form to import tables instead of Access menu
    I just want to open this Access import dialogue and the other work should manually

  4. #4
    ijaz8883 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    103
    Ok leave it I have solved this myself via Macro code

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 02-28-2017, 01:34 AM
  2. Replies: 4
    Last Post: 10-20-2016, 08:22 AM
  3. VBA code import and Add record from excel to MS access
    By darkdarkwt in forum Import/Export Data
    Replies: 2
    Last Post: 07-20-2015, 02:23 AM
  4. Import HTML code fragments to Access
    By NejcZ in forum Access
    Replies: 10
    Last Post: 08-11-2014, 07:32 AM
  5. Replies: 6
    Last Post: 04-26-2013, 03:51 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums