Re: [libreoffice-users] BASE : How add data without primary key

Hi Jean,

Jean Milot schrieb:
> Hi,
>
> I want save my time.

Setting the primary key on table import is 1 click. Avoiding it does not 
save time, but produces trouble.

 I don't want modify all the tables.

?? I thought you want to write data?

> I have a mdb file, so i need already to create all the form so i f i can
> use all the table without modifications.

If you will keep the mdb file untouched, you can do this:

(1) Make a copy of the mdb file and connect to this copy.
(2) Connect to the mdb file and then drag the table to a new database 
using the embedded hsqldb.
(3) Export the access table into Excel format and use it in Calc or 
import it to a new hsqldb.
(4) Export the access table into dBase format and connect to this dBase 
table.
(5) Export the access table into a csv table and use this as text table 
in hsqldb (requires SQL).

You need to tell in more details what you really want to do and why you 
do not simple connect to the mdb file, see option (1).

Kind regards
Regina

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted