+ Reply to Thread
Results 1 to 3 of 3

Don't know how to link a .xlsm file to Access?

  1. 09-08-2017, 10:54 AM #1
    gz3s36
    gz3s36 is offline
    Forum Contributor
    Join Date
    02-06-2014
    Location
    The Show Me State
    MS-Off Ver
    Excel 2013
    Posts
    343

    Don't know how to link a .xlsm file to Access?

    Is there a way to link excel.xlsm to access? I would like to upload data into Access from Excel.xlsm and vice versa.
    Reply With QuoteRegister To Reply
  2. 09-08-2017, 11:21 AM #2
    CK76
    CK76 is offline
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,882

    Re: Don't know how to link a .xlsm file to Access?

    Yes. Use VBA and ADO.

    See link for samples.
    https://www.mrexcel.com/forum/excel-...ess-table.html
    http://software-solutions-online.com...-access-table/

    But's it's far safer to import Excel file from Access side.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein
    Reply With QuoteRegister To Reply
  3. 09-08-2017, 11:29 AM #3
    gz3s36
    gz3s36 is offline
    Forum Contributor
    Join Date
    02-06-2014
    Location
    The Show Me State
    MS-Off Ver
    Excel 2013
    Posts
    343

    Re: Don't know how to link a .xlsm file to Access?

    Thank you CK76. Upon looking at the two sites, I realize it is way above my comfort level. I’ll just continue to copy and paste for now.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to export from xlsm file to xls but original file must stay in xlsm(vba script)
    By martin81 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-03-2016, 09:51 AM
  2. unable to link .txt file in access 2003
    By irfan.rangrej in forum Access Tables & Databases
    Replies: 6
    Last Post: 10-14-2014, 08:51 AM
  3. VBA - how to stop when Saving a XLSM to XLSX with pivottables keeps external link to XLSM
    By judgeh59 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2014, 12:01 PM
  4. [SOLVED] I cannot link to a file with name "Y:\files\# List.xlsm" [Any suggestions?]
    By 1tane1 in forum Excel General
    Replies: 6
    Last Post: 12-11-2013, 05:15 AM
  5. Use Code written in xlsm file to open .xls file and copy-paste data from xls to xlsm file
    By kgiorgosss in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-21-2013, 08:22 AM
  6. Save file xls file as xlsm - macro won't run in xlsm workbook
    By captbluefin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-07-2012, 11:39 AM
  7. [SOLVED] Link Access query to refresh an EXCEL file
    By Dancer4u in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-13-2005, 02:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1