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.
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”
Using the product database, map the queries to the correct “Skinit_Products” table fields as best you can.
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]”.
Clean up any unnecessary tables/queries
See Word File for Clarification.