Text only | Text with Images

coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: dnobendno on September 21, 2006, 08:56:33 PM

Title: Import content from Microsoft Access database
Post by: dnobendno on September 21, 2006, 08:56:33 PM
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
Title: Re: Import content from Microsoft Access database
Post by: Nibbler on September 21, 2006, 09:03:03 PM
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.
Title: Re: Import content from Microsoft Access database
Post by: Stramm on September 22, 2006, 08:48:17 AM
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 '|'
Text only | Text with Images