Import content from Microsoft Access database

[dnobendno]

Sorry if this is on the forum already, I could not find it. I am trying to help a friend manage her art through a database. She has already created a database in Access on her computer. Is it possible to import that content directly into Coppermine?

Thanks,
Dean

[Nibbler]

It's possible, but it's not something that can be explained step by step on a forum. You'll probably need to hire someone to convert the data, there are no tools available to do this that I am aware of.

[Stramm]

I'd use CSV http://en.wikipedia.org/wiki/Comma-separated_values
Basically you change the Access layout to match what Coppermine expects. Then save as CSV... I've seen tools that are able to import CSV into MySQL or you use MYSQL commands...

LOAD DATA LOCAL INFILE 'access.csv'
INTO TABLE `foo` (col1, col2, ...)
FIELDS TERMINATED BY '|'