Results 1 to 2 of 2
  1. #1
    uoghk is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jan 2022
    Posts
    149

    insert records from excel file

    how to ask a Excel file (which is a list of ClientNo,ClientName,PhoneNo)


    then insert all records into Access database?

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Link to it. Then use a query.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Using INSERT INTO to populate/append a linked excel file
    By Sharonann2021 in forum Programming
    Replies: 4
    Last Post: 10-26-2021, 09:21 AM
  2. Add records from an Access table to an existing Excel file
    By MEMFBI in forum Import/Export Data
    Replies: 4
    Last Post: 07-22-2021, 06:48 AM
  3. Insert data to an Excel file?
    By Behedwin in forum Access
    Replies: 0
    Last Post: 02-25-2018, 02:33 AM
  4. Replies: 4
    Last Post: 02-13-2017, 10:08 PM
  5. Replies: 2
    Last Post: 11-14-2012, 08:32 AM

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