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).