|
Importing MS-Access database questions |
Posted in 28th, 10/2004 05:56 by raymond.van.der.sterre |
Hi there,
I have a few questions about importing a MS-Access database:
1. My access database is setup with a user/password. I can only insert the password into the import wizzard. Is that correct?
2. Deleting from the tables is working, but no inserts. When I try the same with an Access database without username/password, it only works table by table and not all at once. Why not?
Please help me, because this is a monthly job I have to do and I hate to export it table by table to Excel and then import the data table by table.
Thanks in advance for your help. Raymond
|
Re: Importing MS-Access database questions |
Posted in 28th, 10/2004 09:36 by support |
Hi,
raymond.van.der.sterre wrote:
Hi there,
1. My access database is setup with a user/password. I can only insert the password into the import wizzard. Is that correct?
Yes it is correct. Actually DBManager doesn't use any User to open the MSAccess DB.
raymond.van.der.sterre wrote:
2. Deleting from the tables is working, but no inserts. When I try the same with an Access database without username/password, it only works table by table and not all at once. Why not?
Can you explain this a little better? I couldn't figure out what you are doing. What do you mean by "table by table" and "all at once"?
Thanks,
Support / DBTools Software
|
Re: Importing MS-Access database questions |
Posted in 28th, 10/2004 09:41 by raymond.van.der.sterre |
What I try to do is:
Use the import wizzard to import a .mdb.
After selecting my MySQL database and selecting the tables I like to import, it is not working.
When I only import one table it is working. When I try to import all 4 tables at once, it fails.
So importing the 4 tables apart is working, but the 4 tables at once fails. And I don't know why. It does delete all data from the tables, but no inserts. Raymond
|
Re: Importing MS-Access database questions |
Posted in 29th, 10/2004 09:31 by support |
Hi,
Have you tried to check the LOGs? If you are not using logs you can enabled this feature at the end of the wizard. Check all prossibilities.
using this options you will end up with a file with all the messages (warning, errors, info, etc) including the SQL statements. THis is very useful to detect problems.
If that doesn't help, could you send a copy of the database so we can test it here?
Thanks,
Support / DBTools Software |
Legends
Topic has Replies
Topic With no Replies
|
|
|