In Progress

Database manipulation with VBA or Macro's -

Hi

I had some previous work done by a freelancer (see below) and the executable was working perfectly but 9 months later the script executable no longer works. I suspect that it it is a software conflict, and i need somebody to troubleshoot it for me. It stopped working Mid November, so i am not certain if it would be something like Java, or .NET Framework.

I need somebody to run the VBA script or to check the script and examine it closely.

Thanks

Angela

========================================================================

Hi,

I would like a script or program that will split a large TXT file, manipulate the data on each of the 10 split files, and then put it all back together again as a CSV so that I can upload it to my website on a weekly basis. At the moment i am doing it manually and it is cumbersome , repetitive and takes hours. The job itself is simple:

FILE 1.

1. Split up a large file (more than 2 GB and cannot be opened by MS Excel due to row restrictions). This can however be done manually if required using Wonderwebware file splitter. Break it up into files consisting of 1 million rows, which will create about 9-12 files.

2. Automate the process of renaming the headers in the first file.

3. Perform some =IF calculations ( i already have these calculations)

4. Perform some find and replace operations

5. Filter out inconsistent data

6. Delete irrelevant columns

6. Convert columns to the correct formats

7. Merge the files back into one large file and upload it. (again this can be done manually if required)

I am thinking a VBA scrip or possible Macro program should be able to cover it, as the tasks are simple, and repetitive but consistent, except for the first file which must have the headers. I have the FULL sequence of events documented.

There are another two formats that need the same kind of manipulation but would need different sequences of events.

FILE 2

File columns vary from the above file.

1. Split the file (as above)

2. open the CSV, using only certain columns which are predetermined

3. Automate the process of renaming the headers in the first file.

4. Perform some =IF calculations ( i already have these calculations)

5. Perform some find and replace operations

6. Filter out inconsistent data

7. Delete irrelevant columns

8. Convert columns to the correct formats

9. Merge the files back into one large file and upload it. (again this can be done manually if required)

FILE 3:

Onix file - need to get it into CSV format and onto my website (SQL Server 2008)

Repeat steps all steps above, but it is a different file format with different columns, so will require its own script.

Get the file onto my website

Skills: Data Entry, Data Processing, Excel, SQL, Visual Basic

See more: vba data manipulation, vba macro large database, software script, manipulate data sql vba, using excel macro manipulate database, database manipulation using vba, database manipulation vba macro, with no restrictions, visual basic 6 freelancer, vba get data from website, vba freelancer job, vba freelancer excel, steps to find a job in freelancer, simple file database, net framework freelancer, my sql create database, ms sql server freelancer, java script freelancer, is possible java freelancer, get more with freelancer, get more done with freelancer, freelancer with excel, freelancer visual basic excel job, freelancer steps, freelancer sql net

About the Employer:
( 4 reviews ) Johannesburg, South Africa

Project ID: #4165579

Awarded to:

djain01

Hi, Pls check my private message for details. Thanks djain01

$15 USD / hour
(31 Reviews)
5.1

24 freelancers are bidding on average $18/hour for this job

srinichal

I look forward to work for the project

$25 USD / hour
(40 Reviews)
5.7
rinsadsl

please find my private message

$15 USD / hour
(20 Reviews)
4.8
diegogarcia0531

Hi, I can do this job, just provide me the actual scripts

$15 USD / hour
(20 Reviews)
4.8
weonlydo

VBA expert, so I can debug this for you. If we're lucky, it'll be a small thing (perhaps you converted to 64-bit Excel 2010?). Otherwise, I'd recommend rewriting the utility in C# which will only work about 10-50 times More

$50 USD / hour
(18 Reviews)
4.7
microk

Expert Here.. Please check PM.

$15 USD / hour
(23 Reviews)
4.2
cheungkc

Hi My query is detailed in PM please

$25 USD / hour
(7 Reviews)
3.0
shagoon2u

Please advise in which language earlier program was developed. If it is Excel/VBA, then please share the file and sample data to work on. Thanks in Advance Shakun Rastogi

$15 USD / hour
(3 Reviews)
2.9
sathish2connect

Hi, I can do this. Ready to start now. Thanks.

$15 USD / hour
(8 Reviews)
2.8
srdas2012

HI ,We are Expert in VB We can do your Job,Please see PMB

$15 USD / hour
(6 Reviews)
2.6
Z03niE

Hy there, I can help you develop an application for this.I have done some similar work before(Converting from Excell to CSV text file).

$15 USD / hour
(1 Review)
1.0
fairgame

Will do it.

$20 USD / hour
(0 Reviews)
0.0
raywings99

I am a developer using vb, vba for excel and msaccess. I have developed salary, wages and leave applications for small and medium size company (SME) in singapore. I could develop a vb app to automate your tasks if t More

$17 USD / hour
(0 Reviews)
0.0
SidrahKanwal

Hi, Do you get any error or the software is just not working as expected? Do you have source available? I have done similar job for an Australian client, i can help troubleshoot and make the app work for you as requ More

$20 USD / hour
(0 Reviews)
0.0
akash9958

You need not to split the file as My code can read it in memory. I have previously written same type of application (700 MB file). My preference would be C# with .Net 2.0 but can code in java also. Award me the proj More

$18 USD / hour
(0 Reviews)
0.0
rockshekhar79

hi am interest on your project plese give me one chance

$15 USD / hour
(0 Reviews)
0.0
KRKans

Hi, I am a chartered accountancy finalist by profession and an expert in excel with good hands on macros and vba... PM box. Thanks

$15 USD / hour
(0 Reviews)
0.0
zkutch

Hello. More 20 years programming experience. see pmb, please.

$15 USD / hour
(0 Reviews)
0.0
hasanmon786

I'm very new but I'm interested to work with you. I understand the work and ready to start right now if you give me chance to do

$15 USD / hour
(0 Reviews)
0.0
andrewarg

Hi, I've got extensive VBA script experience. I'm interested in debug your code and give you a solution. Please check my private message. Thanks.

$15 USD / hour
(0 Reviews)
0.0
tikendrabisht

This is my daily job. I can do this.

$15 USD / hour
(0 Reviews)
0.0