Microsoft Access 2007 FTP CSV file to remote location

I need someone who can Provide me the entire code (step by step) to perform the following action below. I'm not an expert in access nor vba. I have the data base created already. Need to create a button which:
1 - Export / Create a csv file from an specific database table;
2 - Send this csv file to a remote location through FTP connection;
3 - Adds to this FTP action, any images attached to the record.

The end result would be a csv file along with the images sent to my server. The file will then be imported into a mySql database. If there is an easier solution, please advise. I need a solution. a database that can manage a car dealership inventory and have this inventory exported as a csv to my server so it can be available to be showing on my website.

Thank you
EENEYLORNBSJCAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mike EghtebasDatabase and Application DeveloperCommented:
I would suggest to break down your vision/project to samll question first and then put the its pieces together yourself (showing ownership).

- How do I add a button to run a procedure?
- How do I make a CVS file from a table or query?
- etc.

0
EENEYLORNBSJCAuthor Commented:
Okay, let's do that. How do I export data from a table as a csv file?
0
Mike EghtebasDatabase and Application DeveloperCommented:
I just noticed that you are new to EE.

I apologize if may answer is a bit disappointing; but all experts at EE are volunteers with different skill levels. I can answer some of the steps you need but not all.

So, by breaking your project to smaller question, you will have a good chance of get the solution you want. Also, in your questions, it helps to show that you want to learn not get it done by someone else.
Regards,

Mike

0
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

Mike EghtebasDatabase and Application DeveloperCommented:
brb with CVS...
0
EENEYLORNBSJCAuthor Commented:
I know how to add a button, but it exports as a excell file and it doesn't work for me. I need as an csv and later on have this csv ftp to a remote location. Can you help?
0
Mike EghtebasDatabase and Application DeveloperCommented:
I will do my best. Possibly someone will beat me to that. This is how this site works.
0
Mike EghtebasDatabase and Application DeveloperCommented:
DoCmd.TransferText acExportFixed, , "Table1", "C:\FileName.txt"
0
Mike EghtebasDatabase and Application DeveloperCommented:
after typing:

DoCmd.TransferText|
while the cursor at the end of the line, hitting the space bar will give options other than acExportFixed that you may prefer.

Also, change Table1 to the table or query name you have in your database.

This should save FileName.txt at C:\

I will try it myself jut to make sure.

Mike
0
Mike EghtebasDatabase and Application DeveloperCommented:
needs some more work, brb
0
Mike EghtebasDatabase and Application DeveloperCommented:
Ok, I have it. In this line "ABC" is the name of the export specification.

DoCmd.TransferText acExportFixed, "ABC", "Table1", "C:\FileName.txt"

How to get/ create the export specification name?
- From your database window select the table you want to export.
- From the menu, select External Data
- From External section, click on Text File.
- Click on OK
- Make any adjustment on the export layout (for now skip this step we will come to it later.)
- Click on Advance
- Click on "Save As"
- Enter ABC or any relevant specification name you want to give to it.
- Clike on OK.

Now run the line:

DoCmd.TransferText acExportFixed, "ABC", "Table1", "C:\FileName.txt"

This is working.

Mike

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mike EghtebasDatabase and Application DeveloperCommented:
You need to do manual export only once to create a specification like ABC. From that point on, this specification will be available to be reference in your database.


0
EENEYLORNBSJCAuthor Commented:
I appreciate the big help. I'll have to come back on this tomorrow otherwise my wife will divorce me if I don't get home within a hour and I'm quite far. Thank you.

I hope you'll be there for me tomorrow, so I'll see you then
0
Mike EghtebasDatabase and Application DeveloperCommented:
About "- Make any adjustment on the export layout (for now skip this step we will come to it later.)"

Before you click "Advance" button in order to save its specification for a later use, make sure the output file is to your liking. The "Advnace" button will be present for your use until you get to the "Finish" button.

Mike
0
Mike EghtebasDatabase and Application DeveloperCommented:
You are a Premium Service Member. I would suggest for you to close this question when CVS issue is handled. Then, post your next question. With a fresh start like that you will get the attention you deserve. I don't know much about your follow up questions. I possibly will not be much of help to you.

Good luck with your project.

Mike
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.