This forum has been archived. All content is frozen. Please use KDE Discuss instead.

How to import access database in existing kexi database

Tags: None
(comma "," separated)
JeromeP34
Registered Member
Posts
3
Karma
0
Bonjour.
J'ai importé une première base de données access dans une base kexi.
Je souhaite maintenant rajouter les données d'une autre base access dans la même base kexi mais je n'y arrive pas.
Je suis allé dans données externes mais quand je choisi une table à importer j'ai l'erreur impossible d'importer et ça plante kexi.

Hello.
I imported a first Access database in a Kexi base.
I now want to add the data from another access base in the same Kexi base but I can't.
I suspected in external data but when I choose a table to import I have the error impossible to import and it plants kexi.
User avatar
jstaniek
Moderator
Posts
1027
Karma
2
OS
1. Export tables to CSV files in MS Access
2. Import the CSVs into KEXI, possibly into an existing tables


Best regards,
Jarosław Staniek
• Qt Certified Specialist
KEXI - Open Source Visual DB Apps Builder
• Request a feature or fix for KEXI here
May I help you? Please mention your app's version and OS when asking for help
JeromeP34
Registered Member
Posts
3
Karma
0
First I was thinking of directly importing the ACCESS file but I ended up using the CSV files but I'm having another problem.
I have a csv file whose original field is text but whose value of the 1st record is -99 so kexi imports the data as integer and I lose all the values except -99.
is there a solution? should I enter another post?
Thank you in advance.
User avatar
jstaniek
Moderator
Posts
1027
Karma
2
OS
Hi. During the "column type setting" phase of the CSV import KEXI proposes the data type but you're free to change it at this stage.


Best regards,
Jarosław Staniek
• Qt Certified Specialist
KEXI - Open Source Visual DB Apps Builder
• Request a feature or fix for KEXI here
May I help you? Please mention your app's version and OS when asking for help


Bookmarks



Who is online

Registered users: Bing [Bot], Google [Bot], Sogou [Bot]