I have just dumped an Archive of news paper articles from an old MySQL database in to a cvs file. I need to import the info in the fields into my access db which has slightly different field names.

Is there a way of importing one field at a time. A problem may arise because the article Id is an auto number.

Then I have another problem. Is there a way to get rid of HTML tags from a field. The old db had been formated using HTML within the article.

Thanks


Later,

Webcrafty

You can map columns in the Import wizard in Access, or import it as is and use update queries in acces to manipulate it into the right fields one at a time.

:: Son, im Thirty.... ::

I have been trying to import the data and everything works but the "Story" field in the MySQL is a Blob and it is a Memo in Access, I get scrambled letters and code.

Is there a way round this, I changed the blob to long text and it worked fine but I lost most of my data in thet field.

Is there a field in MySQL that can hold over 2000 chars except a blob?

Later,

Webcrafty