Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2010
    Posts
    6

    Red face Unanswered: Regarding importing from excel to access

    hi,
    Actually i have imported my table from excel to access for the first time. and I have changed the records in the excel file and i would like to import the table from excel to access so that i will update my data in the ms access table. I have tried using the button import option. But it didn't work. I haven't written any code for it. So anyone please provide me the solution or any code to import it. Thank you.

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Why not just 'link' the excel file into MSAccess. This then acts like a table in MSAccess whereby you can write queries, etc... against it. (Note: updating data in the excel linked table in MSAccess will also update the excel data itself as well.) You can even design a form based on the excel linked table.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Mar 2010
    Posts
    6
    can you please tell me how to link an excel file to access file so that i can import or update. because i am new to the ms access. Please say in detail please.

Posting Permissions

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