Import content from Microsoft Access database Import content from Microsoft Access database
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

Import content from Microsoft Access database

Started by dnobendno, September 21, 2006, 08:56:33 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

dnobendno

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

Nibbler

#1
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.

Stramm

#2
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 '|'
Print
Go Up Pages1
User actions