Thread Subject: Database

Hello everybody

I really hope to get some help who to contact for questions regarding the database toolbox. I have tried soo many times on the news group but nobody seems to know any solution on my problem. I have copied the post with the problem that nobody seems to have a solution on:

I investigate the possibility to use Access as a database. Therefore I tried to export data from matlab to Access.

I used the function:

colname={'Nike'};

exdata=[1;2;3];

insert(conn, 'New_Price', colname, exdata)

where 'New Price' is the name of the table and colname is the name of the column where the exdata is exported to. When I try to export exdata it all work fine. The only problem is that the exdata is allways copied to the last row in the column Nike also if there are rows above that are empty. My question is how can I control what row in the column Nike the exdata is exported to?

Example


Column Bong Column Nike
66
77
88

Now exdata is exported to column Nike

Column Bong Column Nike
66 ______________
77_______________
88_______________
_________________ 1
_________________ 2
___________ ______ 3

Then lines indicate the separation been the columns.

Instead of exporting the exdata to row 1-3 in the column Nike it is exported to row 4-6 in column Nike

I really need some help:)

Best regards Jesper