J
James Flagg
I have created an ADP file in Access 2002 which connects to a SQL
Server database. It works fine except for a problem that occurs when
I try to import data from an Excel file. Here is what happens:
1. Select "File -> Get External Data -> Import"
2. Select the Excel worksheet.
3. Select "First row contains column headings"
4. Select the destination table. In the list presented, all of the
tables listed have the "dbo." prefix. This should be OK. I'm not
logged in as the dbo, but I have sufficient priveleges.
5. Click Finish. I get the error "The table name 'dbo.myTable' is
invalid"
Now clearly, the name of the table is not invalid, as I just selected
it from the drop-down list presented by the Import Wizard. I don't
believe there is any permissions issue, because I am able to insert,
update, and delete on the table through the ADP file. My user is even
in the db_owner role.
If I change the ADP connection parameters to log in as the actual DBO
user, the import works fine.
So does Access have a problem with scoped table names, and if so why
would it list them in the Import Wizard?
Server database. It works fine except for a problem that occurs when
I try to import data from an Excel file. Here is what happens:
1. Select "File -> Get External Data -> Import"
2. Select the Excel worksheet.
3. Select "First row contains column headings"
4. Select the destination table. In the list presented, all of the
tables listed have the "dbo." prefix. This should be OK. I'm not
logged in as the dbo, but I have sufficient priveleges.
5. Click Finish. I get the error "The table name 'dbo.myTable' is
invalid"
Now clearly, the name of the table is not invalid, as I just selected
it from the drop-down list presented by the Import Wizard. I don't
believe there is any permissions issue, because I am able to insert,
update, and delete on the table through the ADP file. My user is even
in the db_owner role.
If I change the ADP connection parameters to log in as the actual DBO
user, the import works fine.
So does Access have a problem with scoped table names, and if so why
would it list them in the Import Wizard?