Advanced Access VB Build

In Progress

Step One.

I need access database help. I need someone to take template files I provide, and build an access query that will query a main product table “Skinit_Products”, and then output the items as into a query table (ie example “Output_4BuyCom_FTP_Upload”) which I can then export into a text format. (to a nice vb macro button on a form page , and a second one to put the files to a remote FTP directory if possible)

The text column/field format that I need the export to be is provided in the attached text/excels/csv files. The exact format is the text file attached. The sample product database is the attached database; I started this project myself but have been unable to complete it myself. Please take this and run with it.

Step Four

Look at the files provided named “import_source1”, and “[url removed, login to view]” then setup a VB macro to automatically import these methods from “C:\Users\ %USERNAME%\Documents\Feeds\Templates\$templateProviderName”

Step Three.

Using the product database, map the queries to the correct “Skinit_Products” table fields as best you can.

Step Three.

Repeat the Process for each additional Template File I provide. (For now just two “[url removed, login to view]” and “[url removed, login to view]”.

Step Four

Clean up any unnecessary tables/queries

Skills: Microsoft Access, MySQL, SQL, Visual Basic

See more: named query, in process access, database build - i need, build sql, build database sql, need access database help, map csv fields, sql query format, access import txt, remote access setup, project 2013 access, access query table, xls visual basic, export project 2013 database access, sql database import export, project 2013 export access, database template access, sql export ftp, access database text, export project access, import sql ftp, remote access using, access table query, 2013 query, macro import csv

Project ID: #4245957

Awarded to:

Premshanks

I got your requirements and I can do it quicker for you. pl approve the project/milestone and we should do start immediately. thank you.

$75 USD in 2 days
(333 Reviews)
6.4

11 freelancers are bidding on average $141 for this job

frehmanpk

Respected Sir, Please see PMB for details & I m Ready to start immediately. Surety of quality work done with 100% accuracy with attention to detail. Please see attached sample application that how much user friendly More

$200 USD in 1 day
(16 Reviews)
4.5
vietitdotinfo

please check your pmb

$200 USD in 5 days
(13 Reviews)
4.4
FreeLAS

VBA/MS Access Expert

$100 USD in 1 day
(4 Reviews)
3.6
davidt999

I can finish your Access project for you. I have over 8 years of Access experience and have created and updated many projects. I will stick with your project until it performs to your satisfaction. I can start on yo More

$220 USD in 5 days
(3 Reviews)
3.6
srdas2012

Hello Sir,we are Expert in VB/Access We can do this in Vb,Please see Private Message.

$60 USD in 5 days
(8 Reviews)
3.2
bubu77

Hi, Ms Access expert having 8+ yrs of IT experiance. I will be able to help you completing your database. Please see your PM for more details.

$100 USD in 4 days
(1 Review)
2.0
mukulsinha25

Greetings Client, I will be able to help you with your project request. I will provide you with a very robust and accurate project output. I have over 7 years of experience in Excel,Access VBA. I have developed and More

$100 USD in 5 days
(1 Review)
2.0
anomanpk

I would like to offer my services for this job.

$200 USD in 10 days
(1 Review)
1.4
chetanramanuj

I am having more than 12 years of experience in this field/skill, and having mastery is enough.

$50 USD in 2 days
(0 Reviews)
0.0
oobretenov

I have experience in Access and DB design and I could help you

$250 USD in 5 days
(0 Reviews)
0.0