Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2018
    Posts
    19

    Exporting data from Excel to Access


    I've been handed a new OTS software at work. The data utility program creates a blank database at the backend. This contains all the tables with the requisite fields. I have a spreadsheet that has some of the information that needs to be transferred to one table in the blank database. I arranged the columns in my spreadsheet to correspond with the table, added blank fields columns wherever necessary but it still overwrites the fields names in the table. What is the best way to do this data transfer? Should I match the names of the fields and columns perfectly-even the blank ones?

  2. #2
    Join Date
    Apr 2017
    Posts
    1,673
    Link the Excel table into Access as a separate table, and then run an append query to add data from linked Excel table into your Access table.

  3. #3
    Join Date
    Feb 2018
    Posts
    19
    Thanks. That was quick and easy.

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

Similar Threads

  1. Replies: 2
    Last Post: 06-05-2014, 08:29 AM
  2. Replies: 11
    Last Post: 05-09-2014, 11:27 AM
  3. Help with exporting data from excel to access
    By accessrook in forum Import/Export Data
    Replies: 2
    Last Post: 01-22-2013, 12:58 AM
  4. exporting data from access to excel
    By tariq nawaz in forum Access
    Replies: 3
    Last Post: 09-06-2012, 09:29 AM
  5. Replies: 1
    Last Post: 10-19-2011, 07:51 PM

Tags for this Thread

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