+ Reply to Thread
Results 1 to 2 of 2

Linking an Access Database to an Excel Spreadsheet

  1. #1
    Registered User
    Join Date
    11-25-2014
    Location
    United States
    MS-Off Ver
    2013
    Posts
    1

    Linking an Access Database to an Excel Spreadsheet

    I created an Access database and wanted to import the data from an existing Excel spreadsheet. As users input data, it will also import it into Access. The problem I ran across when I linked the Access database to the Excel spreadsheet is that it would not allow other users to input the data onto the Excel Spreadsheet. Is there a way that I can link the Access database with Excel and still have other users to be able to input data onto the Excel spreadsheet?

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,128

    Re: Linking an Access Database to an Excel Spreadsheet

    You cant use the XL sheet if its attached and in use.

    So , Save the 1 excel file to a generic file like File2Import.xls (a copy of the original, staged to import)
    LINK this file as an attached table in access.
    build your queries to import the data to the various tables (these queries should have WHERE [field] is not null, so you dont get the blanks)
    put all this in a macro: mImportXLfiles
    now the import process is just 2 steps:

    1. Get a new excel file, save it to the same import name everytime, File2Import.xls
    2. run the import macro.
    done

    All tables are filled.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Creating an Access Database using Excel Spreadsheet (VBA)
    By awan0126 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-29-2011, 10:00 AM
  2. Linking an excel spreadsheet to a access query
    By excelaspire0219 in forum Excel General
    Replies: 3
    Last Post: 02-10-2009, 10:50 AM
  3. Linking an Access Database with Excel
    By chrismann85 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-08-2008, 01:35 PM
  4. [SOLVED] Linking access database to an excel file
    By PABHL in forum Excel General
    Replies: 1
    Last Post: 06-08-2006, 03:40 PM
  5. [SOLVED] Make an Access Database out of Excel spreadsheet
    By ahmebah in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 02-11-2005, 11:06 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1