Lengkap

Batch import Excel files into Access database(repost)

This is a simple task for someone familiar with Access & VBA

Access version = 2003

Excel version = 2003 & 2007

Note: I cannot send files to coder due to privacy concerns. Coder will have to design using a mockup based on the description I've provided.

I have a directory which contains daily reports that I receive by email (Well over a 100 files file size is between 20 kb & 315 kb).

The reports are in Excel format

All the files follow the same naming pattern

XXX_Daily Prod Report_(DateTimestamp here)

Column names in the Excel files are all the same

ColA = Blank

ColB = Facility

ColC = RecordNumber

ColD = Name (Last, First)

ColE = SeqID

ColF = Room

ColG = Total Score

ColH = Status

Coli = LPoint

Colj = APoint

Colk = Cpoint

Coll = Epoint

I would like to

1. For each workbook in directory that match the criteria *Daily Prod Report_*.xls or xlsx

2. Import sheet named "Report" into Access db to a table named "Importprocesser" the last field in the record should be the filename of the source excel file (Each workbook contains 2 sheets)

3. Macro then needs to query Importprocesser table and insert into Table named "Adjustments" all the records where the field named "Total Score" is equal to or greater than 10 and Status = 'A'

Kemahiran: Microsoft Access, Kejuruteraan Perisian, Visual Basic untuk Aplikasi, Destop Windows

Lihat lagi: room files, named query, excel vba db, design access database, daily access, access database design software, xlsx, vba excel macro, vba access excel, send email excel, reports in excel, name naming, import excel, excel vba macro, excel reports, Excel Macro VBA, database in excel format, c# with access database, c# import excel, c with access database

Tentang Majikan:
( 39 ulasan ) Blue Springs, United States

ID Projek: #2712250

Dianugerahkan kepada:

torajiv

See private message.

$20 USD dalam 3 hari
(166 Ulasan)
6.9

15 pekerja bebas membida secara purata $50 untuk pekerjaan ini

cheapexcell

See private message.

$55.25 USD dalam 3 hari
(163 Ulasan)
6.5
dominique1

See private message.

$45.05 USD dalam 3 hari
(254 Ulasan)
6.2
emova

See private message.

$50 USD dalam 3 hari
(56 Ulasan)
5.4
DenisSmolentsev

See private message.

$68 USD dalam 3 hari
(73 Ulasan)
5.0
Lotusdeveloper

See private message.

$52.7 USD dalam 3 hari
(82 Ulasan)
5.2
MOTASH

See private message.

$68 USD dalam 3 hari
(17 Ulasan)
4.9
ysrahmed

See private message.

$60 USD dalam 3 hari
(58 Ulasan)
4.9
watcher17

See private message.

$34 USD dalam 3 hari
(9 Ulasan)
4.2
wprosolutions

See private message.

$56.95 USD dalam 3 hari
(17 Ulasan)
4.1
manojyohannan

See private message.

$50.15 USD dalam 3 hari
(25 Ulasan)
3.6
olsoft

See private message.

$45.05 USD dalam 3 hari
(11 Ulasan)
3.6
shaarawi

See private message.

$68 USD dalam 3 hari
(23 Ulasan)
3.6
pebravos

See private message.

$34 USD dalam 3 hari
(5 Ulasan)
1.9
mandarfreelancer

See private message.

$42.5 USD dalam 3 hari
(2 Ulasan)
2.4