Færdiggjort

MSACCESS 2000 Data Manipulation from Text File

I have a text file that is downloaded in a format unusuable without doing column mainpulation in excel with various formulas. For Example I use IF(B:2)="",(B:1),(C:2) to have a field name populated into empty cells. I would like some VBCode that can allow the Database to run through and populate the fields with the previous record's data if the same field is Null in the Current Record using a primary number ID or some other method that will work on a monthly basis with the same file. Can send Sample Spreadsheets showing current methods.

## Deliverables

1) Complete and fully-functional working Access 2000 database using the provided text file reworked in necessary format as well as complete source code of all work done.

## Platform

MS Access 2000

Evner: Ingeniørarbejde, Microsoft Access, MySQL, PHP, Software Arkitektur, Software Testning, Visual Basic

Se mere: primary data, text file, data to text file, access 2000 database, text manipulation, number manipulation, visual basic database excel database, sample visual basic excel, column text, excel text column, populate spreadsheets, access database manipulation, populate excel excel file, excel sample data manipulation, excel file data manipulation, monthly database excel, visual basis, can send sample, php excel manipulation, text database access

Om arbejdsgiveren:
( 1 bedømmelse ) United States

Projekt ID: #2892945

Tildelt til:

rgaylog

See private message.

$42.5 USD in 14 dage
(4 bedømmelser)
2.0

7 freelancere byder i gennemsnit $48 på dette job

peterjl

See private message.

$25.5 USD in 14 dage
(75 bedømmelser)
5.3
niosop

See private message.

$21.25 USD in 14 dage
(24 bedømmelser)
5.1
pvavw

See private message.

$85 USD in 14 dage
(39 bedømmelser)
3.9
mmcwhirter

See private message.

$42.5 USD in 14 dage
(2 bedømmelser)
3.1
bravevw

See private message.

$82.45 USD in 14 dage
(0 bedømmelser)
0.0
code2livevw

See private message.

$38.25 USD in 14 dage
(1 bedømmelse)
0.0