noob Creating a macro to convert to csv.

C

craigyk

Hi

I am new to macros and access but this is what i want to acheive:

I have an access table that contains over 50 columns (A to ZZ) which i
am currently converting in a macro to a csv file for importing later
into a mysql database.

The actions in my macro are as follows:

TransferDatabase (makes a copy of the data)
TransferText (copies the data to a csv)
DeleteObject (deletes the recently copied table)
Quit

Is there a way in the transfer text function part of the macro to only
copy one specific column from within the table???


Many thanks for any help / advice

craig
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to copy table of contents to a new doc 0
Cannot import CSV file into ACCESS 1
Macro to open CSV files 6
Import Excel or CSV File Using TransferSpreadsheet or TransferText 1
Error When Using TransferText in a Macro 1
copy and save as csv 4
How to create macro to change value in CSV. 0
Error Message Cannot Update Database is Read Only Error 2950 0

Top