login
Forgot?
Login with Facebook

Don't have an account? Register one now!

Need MS Access/Excel Guru

Bids 
13
Avg Bid
N/A
CLOSED
  • Project ID:

    617462
  • Project Type:

    Fixed
  • Budget:

    $750-$1500 USD

Project Description:

Currently we have an invoice and reporting system using Access 2000, we import a delimited text file, that is in a sequential order, which populates the database that the queries pull from. Currently Access is setup to work on a text file layout of the current delimited text file (sequential order is important), we now have two new text files, which need to be merged and put into the same delimited format as the older file in order to use our current Access program.

If you cannot merge the text files then need the Access program to be altered to use the old layout and configured to accept the two new delimited text files in order to populate the same reports.
Must have proven background in Access, need this done ASAP 2-3 day timeframe.

Skills required:

Excel, Microsoft Access, MySQL, PHP

Project posted by:

RenyCo United States
(23 Reviews)

Last seen:

Public Clarification Board

2 messages

  • sathy

    Sir/Madam,

    We can do the required modification in existing Ms-Access or merge the new two text file. Please send us the new file format and existing access DB.

    Thanking you in advance,

    sathishsayee

    over 1 year ago

  • refractocd

    Do you want to say that the format and/or number of columns in these 2 new text files is different from the text file which you are currently being imported. Lets say your Access program works perfectly when there are, say, 12 columns in text file in predefined sequence. Now you have 2 new text files which have, say. 15 columns in a different order. Now, you want to remove 3 columns and arrange the order of remaining columns to match that of original text file. Have I followed?

    Please provide exact specifications. It will be beneficial if you load sample of original text file as well as 2 new text files or a portion of it.

    over 1 year ago


If you are the project creator or one of the bidders, please Log In for more options.


Bids are hidden by the project creator. Log in as the project creator or as one of the bidders to view bids. You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

All Bids ()