Käynnissä

Write VBA procedure to import Excel sheet into Access table

I need a VBA procedure written in Access that imports a spreadsheet from Excel into a table. I need it ASAP!

The spreadsheet and Access database are attached. Customer data was blanked out so ask if you have any questions . . but I think the column names are self explanitory.

Notes . . . . the customer (in cell B) and the job number (in cell C) are not repeated in every row for a particular job or customer, so you must insert those manually. (see spreadsheet).

Taidot: Excel, Visual Basic

Näytä lisää: vba import excel access, import procedure access vba, import procedure excel access, access import procedure, import excel access, vba import excel, import excel access vba, write names, table customer, customer table, ask excel, access vba insert, sheet table vba, excel vba insert table, vba import excel table, import access table, vba import sheet, importing excel access vba, vba excel insert sheet, vba import worksheet access, visual basic access table, access vba import xls, write vba procedure access, vba import html table, import procedure vba

About the Employer:
( 32 reviews ) Mt. Vernon, United States

Projektin tunnus: #475509