Back to discussion

Importing Data from EXCEL to ACCESS Table

Last post was 21 Jul 2007 at 12:37
access Exeter, United Kingdom
  • 13 years ago

    Hi

    I was wondering if anyone could give me some sample VBA code which would allow you to import data from an EXCEL spreadsheet into an Access Table?

    Many Thanks

    John T

    Report abuse
  • 13 years ago
    DoCmd.TransferDatabase should work for you.

    http://msdn2.microsoft.com/en-us/library/Aa164087(office.10).aspx

    Tim





    Report abuse

Post a reply

Enter your message below

Sign in or Join us (it's free).

MS Access forum discussion

Quick links

Recent activity

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Web Development

Developer Jobs

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

Cancel
“Theory is when you know something, but it doesn't work. Practice is when something works, but you don't know why. Programmers combine theory and practice: Nothing works and they don't know why.”