I gang

Create database for 40M record file with reporting interfac

I have a 40M record address file that I want to upload and update monthly. I will have an initial setup of the base file with 40M records, and then monthly additions and subtractions. The file record format is described in the attached [url removed, login to view] file. I've also attached a sample file 979.txt.

I will receive the 40M record file in approximately 1000 txt files like the one attached. (sorted by zip code) I want an automated process to upload these into the database. I also want to automate the update of additions and subtractions.

I then want to run reports off of this database to create new csv files, creating simple reports of about 70K rows. (e.g., consolidate data to 5 digit zip code from 9 digit zip code).

I don't know if there is a way that Access can handle this. Would love it if so. I also have a webserver with a mySQL database, but would like something integrated with a front end where I can run reports (I don't know if access will work for this or not, but would be great if it would). This does NOT need to be integrated to the web, as I will be the only one to use it.

Please give me an understanding of what you propose to develop for the final specs. I think this should be a very simple job as the DB is only 2 tables and the links are very defined already. If it weren't so large I could just do it myself in access in a few minutes

Færdigheder: Microsoft Access, SQL

Se mere: sample access create file record database, simple reporting, simple file database, front end reporting, do it for the love, t-sql with, create new web address, upload database, integrated database, develop database, creating sql, create e, consolidate, web front end develop, create zip code, can automate file upload sql, update sql file, access creating reports, sql final, code create, create access database reports, create simple access database, sql update txt file, web reporting sql database, update database mysql

Om arbejdsgiveren:
( 12 bedømmelser ) Hastings on Hudson, United States

Projekt-ID: #609360

14 freelancers are bidding on average $163 for this job

piyushdpatel

Hi This is Piyush Patel I have 5 yrs of Exp in VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM

$150 USD in 2 dage
(9 bedømmelser)
4.7
DBguy

Good Evening. I can get this done for you really quick. Please check your PMB. Thank you for your consideration. Best Regards.

$100 USD in 2 dage
(16 bedømmelser)
4.6
djucuti

Hello, Please see PM

$80 USD in 3 dage
(16 bedømmelser)
4.5
KellogITSolution

Hi Ready to start right now. Please see your PMB for details. With Regards John

$110 USD in 5 dage
(26 bedømmelser)
4.5
servicebenq

Hi Check your PM please. thanks

$185 USD in 4 dage
(12 bedømmelser)
4.3
ivancp

Hello, Please read the PM

$170 USD in 3 dage
(6 bedømmelser)
3.8
oFAZo

Exceptional quality & Quick work. Please refer to Profile & PMB for details. Thanks FAZ

$175 USD in 2 dage
(3 bedømmelser)
4.2
DISoln

Please check PM for my Proposal

$450 USD in 20 dage
(2 bedømmelser)
2.4
aamirhs

Hello Sir. Please view PM.

$50 USD på 1 dag
(2 bedømmelser)
2.4
Kingpin1962

Kindly check PMB. Thanks...

$200 USD in 10 dage
(0 bedømmelser)
0.0
rasantse

Hello. I'm a software engineer and can solve your problem in a timely manner, finding you a quality solution. Please see my private message for justification of my bid. Thanks in advance and good luck with your project Mere

$210 USD in 3 dage
(0 bedømmelser)
0.0
gaait

I will be able present you a working demo in 1 day, next 2 days for finetuning in close cooperation with you or someone else. Hope to hear from you.

$200 USD in 3 dage
(0 bedømmelser)
0.0
deemas

We have already tool to import XML/Excel files to Ms Access database, we have done this in one of our application to a client. if you are interested we are ready to start

$105 USD in 7 dage
(0 bedømmelser)
0.0
zaibtiger

I can do this as per required. refer it to me I am MCDBA and know how to manage data in simple and technical way. thanks and best regards

$95 USD in 3 dage
(0 bedømmelser)
0.0