В работе

Build a Database from Multiple Excel Files

I need an application program (.exe and source) or Excel VBA to read a sequence of Excel files and extract specific information from each file.? The program should:? read a file, extract the specific information from a single worksheet, output the information to four different Excel worksheets based on a commodity title (i.e., wheat, corn, oats or soybeans), read the next file, extract information and append it to the correct worksheet to build a database, etc.? Note that the files you will read are all saved in the Excel 1997-2003 worksheet format, but if you write a macro for Excel, it should work in the Excel 2007 version; that is, the macro should run in Excel 2007 with the output produced in either 1997-2003 or 2007 formats??"I don’t care which format you use for the output file.

I’ve included a sample set of Excel files for download, which in practice will be in the same folder. On each of these files, I’ve highlighted the information to be extracted.? I’ve also provided an example of the output file/database structure that is required. ? The output file shows you the layout and the specific data that must be extracted. Also note that if there are blanks in a number field the entry is to be are coded as a zero; however, if a date field is blank, leave it blank.?

An initial DEMO in your response increases the chance of being selected.

Навыки: Техника, Excel, Microsoft Access, Microsoft Exchange, MySQL, PHP, Powerpoint, Управление проектами, Архитектура ПО, Тестирование ПО, Word

Показать больше: formats in excel, data entry in excel 2007, excel vba or, excel database data entry and management, wheat, vba excel macro, vba e, excel vba macro, Excel Macro VBA, database required in excel, database in excel format, build a program, project database vba excel, multiple excel, excel macro download file, extract excel files, write macro, read structure file, excel project use database, excel vba read files, excel macro read data files, data entry worksheet excel, response layout example, excel 2007 vba, 2003 macro 2007

О работодателе:
( 15 отзыв(-а, -ов) ) United States

ID проекта: #3801789

Поручено:

iLoveCoding

See private message.

$85 USD за 3 дней(-я)
(74 отзывов(-а))
5.2

15 фрилансеров(-а) подали заявки на эту работу; средняя заявка - $94

fastudiovw

See private message.

$106.25 USD за 3 дней(-я)
(731 отзывов(-а))
7.5
jacobdd1

See private message.

$106.25 USD за 3 дней(-я)
(268 отзывов(-а))
7.1
schandraram

See private message.

$106.25 USD за 3 дней(-я)
(160 отзывов(-а))
6.9
slavisatosic

See private message.

$85 USD за 3 дней(-я)
(113 отзывов(-а))
6.0
tusharjohri

See private message.

$85 USD за 3 дней(-я)
(82 отзывов(-а))
5.6
alekscoder

See private message.

$85 USD за 3 дней(-я)
(163 отзывов(-а))
5.5
durlabhvw

See private message.

$85 USD за 3 дней(-я)
(24 отзывов(-а))
4.8
jebastine

See private message.

$93.5 USD за 3 дней(-я)
(55 отзывов(-а))
4.7
mahfuzmurshed

See private message.

$93.5 USD за 3 дней(-я)
(74 отзывов(-а))
4.6
jyotirags

See private message.

$85 USD за 3 дней(-я)
(16 отзывов(-а))
4.3
kantpuneet

See private message.

$85 USD за 3 дней(-я)
(4 отзывов(-а))
3.1
solutionizers

See private message.

$91.8 USD за 3 дней(-я)
(5 отзывов(-а))
2.2
investOmatics

See private message.

$106.25 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
LSIT

See private message.

$106.25 USD за 3 дней(-я)
(0 отзывов(-а))
0.0