In Progress

Extract data from MDB files

I posted this before but was requesting an application to do the data extraction. I no longer want the application, just the data. Here is what the project entails....

There is an application called AutoQuotes ( [url removed, login to view] ) it pulls up restaurant equipment current list prices, images, descriptions, dimensions, weight, specs, specification sheets, etc. I have the data files (they are in MDB format.. i.e. MS Access Databases) The information is stored in what it calls 'long binary data' , the images, the pdfs, and the text data fields. I need the data extracted from those databases and stored as follows:

1) Text information stored in an excel spreadhseet, the rows that I need on the spreadsheet I showed an example of and attached the file below.

2) Image data needs to be saved to a folder. The images need to be saved as the products model number and in jpg format. For example, a True TBB-2-G is a product in the database and the image should be saved as [url removed, login to view] , that won't be hard because right now the images are pulled up in the autoquotes program as, for example the True product would be TruTBB-2-G, so you just need to remove the manufacturers partial name from the beginning of the filename. The program FileBoss can do that automatically once you have all the images saved.

3) The cutsheets (product spec sheets in PDF) are also stored in that 'long binary data' format in the MDB files. Same as above the PDFs need to be saved with the model number as the name, for example the 'True manufacturing Co.' item from above would be saved as [url removed, login to view] (and just like the images the autoquotes program already stores the data as [url removed, login to view] so you would just need to remove the shortened manufacturer name from the files after you have them saved. Once again the 'FileBoss' application that you can download for free can do that automatically so that won't be hard.

PLEASE NOTE: This is NOT a simple 'open the MDB with some data conversion software and convert it to excel format' , if it was that simple I would do it myself. You can look at one of the MDB files at this link: [url removed, login to view] , the file is password protected, PM me for the password. I uploaded also an image of the programs window that shows the fields I need to extract from the database. So you can see those fields and the sample Excel spreadsheet I made with the rows the sheet will have to have, and looking at those and then one of the actual MDB files (at the link above) should give you all the information you need to decide the rate for this project and the time you will need.

Payment will be made via GAF escrow as soon as bid is accepted, and funds will be released upon completion and successful testing of excel data, image files, and pdf files.

PLEASE NOTE ALSO: The Excel sample I attached contains many rows, there are items that do not use all those rows, and some that use rows that are not on that spreadhseet. Simply add rows if there are more available rows for different items (for example a stove will not have the 'refrigeration field' so leave it blank of course, but it will probably have another field like 'gas or electric' or 'electrical configuration' etc.

Skills: Data Entry, Engineering, Excel, Visual Basic, Windows Desktop

See more: extract mdb file, extract data mdb file, extract data mdb, extract mdb, extract mdb files, mdb extract, extract files mdb, extract mdb data, extract text data mdb file, extract images mdb, extract file mdb, extract data mdb files, extract mdb file excel, extract files mdb files, sample mdb file, mdb binary data, access binary data extract, sample mdb files, extract binary data mdb, extract data access mdb, access extract binary data, mdb format specification, mdb binary file specification, extract tables mdb file, extracting mdb files

About the Employer:
( 28 reviews ) Miami, United States

Project ID: #236885

Awarded to:


Please see PMB

$60 USD in 3 days
(42 Reviews)

20 freelancers are bidding on average $119 for this job


VBA developer since 1997. This doesn't seem to be an easy one. Anyway, I'll automate the process with VBA. Regards, Svet

$230 USD in 7 days
(74 Reviews)

Hi, check your pmb please

$100 USD in 5 days
(63 Reviews)

Hi, Please See PM. Thanks

$200 USD in 5 days
(18 Reviews)

Please, check PM.

$85 USD in 2 days
(9 Reviews)

What i want is only your reviews ,i'll work 4 u under "1" dollor.

$99 USD in 5 days
(5 Reviews)

I have over 8 years of data extraction and programming experience. I can get this project done on a timely basis. I'm a native English speaker, and have excellent communication skills. Check out my profile for more inf More

$125 USD in 2 days
(5 Reviews)

Please see PMB

$150 USD in 2 days
(3 Reviews)

Pl see the PM.

$100 USD in 2 days
(3 Reviews)

I can do this project. Hope have a chance work for you. Thanks & regards.

$100 USD in 5 days
(1 Review)

Hi, I'm interested in working on this project. I have worked on similar projects before and met the expectations and promise to deliver the same with this project. I have worked on "[login to view URL]" or www. [login to view URL] More

$200 USD in 10 days
(0 Reviews)

Experienced DBA; please see pm.

$100 USD in 3 days
(0 Reviews)

Hi, I understand you project requirements, and I assure you that I can complete it within 2-3 days . You can surely rely on my company for this project. Regards, Suvo.

$115 USD in 2 days
(0 Reviews)

hello, please check PMB

$30 USD in 0 days
(0 Reviews)

I want to engage in the project.

$70 USD in 7 days
(0 Reviews)

I can really do it as your terms. you have to pay. i will do it. its definetely

$250 USD in 10 days
(0 Reviews)

Please, check PM

$210 USD in 15 days
(0 Reviews)

Hi, I am very much interested to work in the field MS [login to view URL] see PMB.

$30 USD in 5 days
(0 Reviews)

let me start.

$30 USD in 2 days
(1 Review)

Sir, Please refer to my PMB

$100 USD in 5 days
(0 Reviews)