+ Reply to Thread
Results 1 to 2 of 2

How to Save Automatically Document-like layout in Excel to Access in a Document-type Form

  1. #1
    Registered User
    Join Date
    09-18-2018
    Location
    Philippines
    MS-Off Ver
    2016
    Posts
    1

    How to Save Automatically Document-like layout in Excel to Access in a Document-type Form

    Hey guys. I was wondering if you have any idea how to automatically save data in excel into database like Access. The problem is that the file in Excel is not in tables but it's constructed in a document-like layout. I would like to use the file from Excel as a form wherein each data entered is automatically stored in the database but also in a document-like layout, just like how it used to be in Excel. There is certain no. for each document which will serve as primary key for filtering the document. If you've got any idea, please let me know. Thank you so much.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: How to Save Automatically Document-like layout in Excel to Access in a Document-type F

    So long as your Excel file looks like a table but is formatted as a range then you can link your "table" to Access and it will work as if it were a table in Access.


    https://support.office.com/en-us/art...d-e084913cc958
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Auto-fill form, save as document, and then print
    By slikpurse in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-04-2017, 11:44 AM
  2. [SOLVED] Create and Save a new word document from user form
    By rob_h in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-15-2017, 06:09 PM
  3. Replies: 3
    Last Post: 02-27-2014, 12:06 PM
  4. Replies: 0
    Last Post: 09-19-2013, 05:01 AM
  5. Replies: 5
    Last Post: 10-01-2008, 08:30 AM
  6. Replies: 0
    Last Post: 06-23-2006, 01:15 PM
  7. Replies: 3
    Last Post: 05-09-2005, 03: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1