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

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

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