Importing Data from a table in another database 1

[globalstrata]

How can I do this? Can I do:

INSERT INTO [database1].[dbo].[table1]
       ([Column1], [Column2], [Column3])
Select [database2].[dbo].[Column1],
       [database2].[dbo].[Column2], 
       [database2].[dbo].[Column3]
FROM   [database2].[dbo].[table2]

Is that the exact syntax? Do I include the brakets? The reason I am asking is because I am getting the following error for each of the fields of the second database:

The multi-part identifier "databse2.dbo.field1" could not be bound.

Thanks in advanced,


Gladys Rodriguez
GlobalStrata Solutions
Computer Repair, Website Design and Computer Consultant
Small Business Resources

 

[gmmastros]

Your missing the table names

INSERT INTO [database1].[dbo].[table1]
       ([Column1], [Column2], [Column3])
Select [database2].[dbo].[!][table2][/!].[Column1],
       [database2].[dbo].[!][table2][/!].[Column2], 
       [database2].[dbo].[!][table2][/!].[Column3]
FROM   [database2].[dbo].[table2]

Usually, people will use aliases to make the syntax easier to read, like this...

INSERT INTO [database1].[dbo].[table1]
       ([Column1], [Column2], [Column3])
Select TableFrom.[Column1],
       TableFrom.[Column2], 
       TableFrom.[Column3]
FROM   [database2].[dbo].[table2] As TableFrom

And technically, since the select part is only looking at one table, there wouldn't be any ambiguity regarding the fields (which table they belong to) so you can omit the alias all together, like this...

INSERT INTO [database1].[dbo].[table1]
       ([Column1], [Column2], [Column3])
Select [Column1],
       [Column2], 
       [Column3]
FROM   [database2].[dbo].[table2]

The square brackets exist to allow you to use names that contain spaces or are reserved words. For the database/table/columns you show here, they wouldn't be necessary. However, they don't hurt to have them, either.

Hope this helps.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom