How do I transfer a Set of data from an exsisting Excel Data Sheet to an existing Access Tables (using VB for Excel)? RRS feed

  • Question

  • Hi,

    I have an excel file with 5 columns with 5 rows of data. I would like to read each line in excel and transfer the data into three different tables in Access database. Is this possible...? If so please provide me with codes. I am new to VB.

    Excel file:

    Columns- id,Name, Weight, Height,Length

    Access tables:

    DetTB- has ID, Name

    SpecTB- has Weight, height, length

    Thanks in advance!

    Sunday, January 11, 2015 7:13 PM


All replies