Results 1 to 1 of 1
  1. #1
    Join Date
    May 2013

    Unanswered: Populate a table in MS access with excel data

    Hi All,

    I have created tables in MS Access 2003. I want to update a table in ms access with the laboratory result in .xls format. The laboratory file has 7 column Heading which are placed in one Field,am attaching the lab file and ms access table all in .txt, which i want to be updated, have loaded manually one record so you may see what I mean. My problem is coding so that what am importing will be transformed from record to Column and to make it a permanent solution whenever I want to update the same table, Please assist.

    Many thanks in advance,

    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts