CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. August 24th, 2001, 10:22 AM #1
    Jamie Jerome
    Jamie Jerome is offline Junior Member
    Join Date
    Aug 2001
    Location
    New York, USA
    Posts
    2

    How can I update an access table using an excel file?

    Could anyone please help me with the VB code for importing an excel file into access and/or updating an existing access table using an excel file that is saved in a fixed location i.e. (c:\temp\students.xls

    Jamie

    Reply With Quote Reply With Quote
  2. August 27th, 2001, 01:12 AM #2
    makai
    makai is offline Member
    Join Date
    Jul 2000
    Location
    Hawaii
    Posts
    281

    Re: How can I update an access table using an excel file?

    you can connect to an Excel file just like Access with a Data Control - click on the connect property to see your Excel connection options

    I would suggest using another control for your Access DB then loop through rows of Excel with .MoveNext and then - use .Addnew, field assignments, and .Update in the Access DB

    http://pub13.ezboard.com/bvisualbasicexplorer
    Reply With Quote Reply With Quote
  3. July 30th, 2002, 11:14 PM #3
    Beginner2002
    Beginner2002 is offline Member
    Join Date
    Jul 2002
    Location
    USA
    Posts
    138

    having the same prob

    Hi Jamie
    Did you find a way to do it ? How did you go about it ..I have the same problem .
    Thanks ..
    ThankYou
    Beginner
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured