html form to MS Access?

J

Jason Miles

Hi,

I have a site which uses a form. I would like to be able to export the data
from the form to MS Access. Some of the fields may contain commas, which I
think may be a problem.

Can someone show me how to take the info from the form and export it to MS
Access?

Thanks,
Jason
 
M

Mothra

Jason said:
Hi,

I have a site which uses a form. I would like to be able to export the data
from the form to MS Access. Some of the fields may contain commas, which I
think may be a problem.
That is a problem. Get your CGI script to strip out commas from any
fields. Either that or use a different field separator.
Can someone show me how to take the info from the form and export it to MS
Access?
Save your form as a CSV file (generic term - you may not be using
commas). You would then import it into MS Access - there is a built-in
facility to do this - check the MS Access help for details.
 

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

Members online

Forum statistics

Threads
473,755
Messages
2,569,536
Members
45,020
Latest member
GenesisGai

Latest Threads

Top