Need script to convert Access table to comma-delimited file

[kevinj]

I have an Access 2002 database that contains 5 tables and is used by my client's web site. I need to set up a feature that will allow my client to click on a link to download a comma-delimited file of the current version of 1 of the tables so they can import the file into FileMaker Pro. Any help would be greatly appreciated.

[hakre]

maybe that's why you're asking, but if you've got access you can export the table via the file menu to a csv (comma seperated values) file and you won't need a script for this.

[kevinj]

Yes I do know that that is possible. I have set up an admin section for the client to login and in that section I want to let them just click on a link to download the csv file. They have never used Access and I want to make this as easy as possible for them.

[hakre]

then i would suggest that you'll create a macro out of it. just record that action and then see the vba code later on. you just modify it for your needs then. voila: script is ready.