Results 1 to 3 of 3
  1. #1
    PandoraGirl is offline Novice
    Windows 10 Office 365
    Join Date
    May 2022
    Posts
    10

    Export Data in Spreadsheet Form

    I asked this question on another post but realized it was completely different than the question I originally asked. I have been using Excel for our budget templates, which takes a lot of prep and rework (the managers tend to type over our formulas, etc.). I am trying to see if I can utilize Access going forward. I can see how the data can be entered into Access but we will need to export it into a format that we can use to upload into our financial system. I have attached a sample database file and an Excel file that has a Maintenance Agreements tab, so you can see how we have been doing it (this is one tab of a multiple tab file), and an Upload tab, which shows the format of the data we will need to export. I thought a query or report would be the best option but not sure how to do that without "committing spreadsheet". Any help you can give would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    access can export the data in the basic table layout, but afterwards you will need vba programming
    to do the color formatting and and subtotals.

  3. #3
    PandoraGirl is offline Novice
    Windows 10 Office 365
    Join Date
    May 2022
    Posts
    10
    ranman256, thank you for your reply. I am not trying to export in the Maintenance Agreements tab format. I am trying to export in the Upload format. I don't know how to create a query or report to take the data entered in Access for Maintenance Agreements and get it in the Upload format to export.

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

Similar Threads

  1. Export Form's Record Source To Excel Spreadsheet
    By Bcanfield83 in forum Forms
    Replies: 1
    Last Post: 04-18-2019, 03:18 PM
  2. Export Data to an Existing Excel Spreadsheet
    By wcrimi in forum Import/Export Data
    Replies: 16
    Last Post: 09-09-2018, 03:50 PM
  3. Replies: 5
    Last Post: 08-26-2018, 07:54 PM
  4. export to spreadsheet
    By slimjen in forum Import/Export Data
    Replies: 1
    Last Post: 07-25-2012, 04:15 PM
  5. Replies: 1
    Last Post: 08-12-2010, 10:04 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