Quest simultaneously creates multiple tables and Access Database databases and imports them to SQL.

1. When I first created an Oracle database table, I wanted to execute multiple tables at a time. I did not expect to click Executestatement, and I always reported a syntax error. You can refer to ExecuteasScript to create multiple tables. 2. I cannot import data from the Access Database today. First, my Access database has a password.

1. When I first created an Oracle database table, I tried to create multiple tables at a time. I did not expect to click Execute statement, and I always reported a syntax error. I will ask someone to say Execute as Script to create multiple tables. 2. I cannot import data from the Access Database today. First, my Access database has a password.

1. When I first created an Oracle database table, I tried to create multiple tables at a time. I did not expect to click Execute statement, and I always reported a syntax error. I will ask someone to say Execute as Script to create multiple tables.

2. I cannot import data from the Access Database today. First, my Access database has a password. The reason is that the database has a password. The following is my solution.

I. Back up the Access database temp. mdb

2. Setting the temp. mdb file does not require a password. This step is critical.

3. Open temp. mdb with Access2003 (open in exclusive mode and set it in the open arrow). In this way, the Access password is removed.

4: Use the SQL Enterprise Manager to export data.

The above is my little experience. I hope you can give me some suggestions.