Käynnissä

Advanced Access VB Build

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

Taidot: Microsoft Access, MySQL, SQL, Visual Basic

Näytä lisää: named query, process access, 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, 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 export access, access table query form

About the Employer:
( 12 reviews ) San Diego, United States

Projektin tunnus: #4245957

Myönnetty käyttäjälle:

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 2 päivässä
(333 arvostelua)
6.4

11 freelanceria on tarjonnut keskimäärin 141 $ tähän työhön

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 Lisää

200 $ USD 1 päivässä
(16 arvostelua)
4.5
vietitdotinfo

please check your pmb

200 $ USD 5 päivässä
(13 arvostelua)
4.4
FreeLAS

VBA/MS Access Expert

100 $ USD 1 päivässä
(4 arvostelua)
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 Lisää

220 $ USD 5 päivässä
(3 arvostelua)
3.6
srdas2012

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

60 $ USD 5 päivässä
(8 arvostelua)
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 4 päivässä
(1 arvostelu)
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 Lisää

100 $ USD 5 päivässä
(1 arvostelu)
2.0
anomanpk

I would like to offer my services for this job.

200 $ USD 10 päivässä
(1 arvostelu)
1.4
chetanramanuj

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

50 $ USD 2 päivässä
(0 arvostelua)
0.0
oobretenov

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

250 $ USD 5 päivässä
(0 arvostelua)
0.0