MS SQL question

[skarosi]

Dear all, i know that this might not b the best place for such a question, but i am not sure where i should ask it.
anyway, I want to import some data to MS SQL server 2000 from MS Access. I have found an option in the SQL server, that theoretically copies the DB and it suppose to work, at least it tells me that the table has been copied.
The problem is, that i cant find the table on the DB it tells me.
for example i import table named "Access_Table" to the server "New_DB_Server", and it says that it has been copied, actually it says that the destination in "[New_DB_Server].[dbo].Access_Table", but i cant find it anywhere.
Can you pls help me with that? Thanks

 

[Erics44]

Hi
So in your enterprise manager you have gone into a specific database and selected Import Data?

thanks

 

[skarosi]

yes, but it doenst seems to work

 

[Erics44]

did you do it by right clicking tables and then ALL TASKS and the IMPORT DATA?

 

[Erics44]

sorry, that probably seemed a bit patronising but I havent ever had any problems with that before so I cant suggest anything

 

[SQLBill]

Are you the DBO? Do you have access to the SQL Server database? Do you have access to the SQL Server table?

How are you trying to "find it"?

-SQLBill

 

[skarosi]

SQLBill, I am not sure what the DBO is, i have access to the DB and to the other tables on it, i just cant find the table imported from MS Access,
Erics44, yes, thats how i do it
Thanks

 

[SQLBill]

DBO = database owner.

Have you refreshed your view in Enterprise Manager?

If you aren't DBO, you may not have permission to see the table. (But then you shouldn't have been able to import it either).

-SQLBill

 

[skarosi]

OK, ppl
it is working, thank you all

 

[SQLBill]

So what was the solution?

Always acknowledge or post the solution to your issue. It might help someone else later on.

-SQLBill

 

[skarosi]

it seems that i had to close the programm once, but also it was not getting the tables with the right names, actually it didnt copy the name file as it was.
Thanks again everybody