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, access vba import excel sheet, vba import excel, import excel access vba, write names, table customer, customer table, ask excel, vba procedure import excel access, access vba insert, excel table import access table procedure, import excel access table vba, sheet table vba, excel vba insert table, vba write table insert access, vba access import excel sheet access table, vba import excel table, import access table, import particular sheet access vba, access procedure import data excel access, import access table excel sheet vba

Tietoa työnantajasta:
( 32 arvostelua ) Mt. Vernon, United States

Projektin tunnus: #475509