Message
From
02/03/2010 17:45:28
To
02/03/2010 17:42:49
General information
Fórum:
Microsoft SQL Server
Category:
Import/Export
Título:
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
ID da thread:
01452152
ID da mensagem:
01452161
Views:
44
>>>Hi,
>>>
>>>I have a .mdb file (I guess this is an Access database) that someone sent me. I don't know the version of this Access database. I need to import it into my SQL Server 2005. I found an article on the web describing SSIS as a way to import the database. My primary concern is not to break anything in my SQL Server 2005. Is this (SSIS) method a safe and efficient method of importing Access into SQL Server? Or would you recommend another approach?
>>>
>>>TIA.
>>
>>You won't break anything in SQL Server (this ain't VFP anymore) with a SSIS import. Just make sure you import to a new database so you can look at your data once it is imported and verify you got what you think you were getting before putting it in a production database!
>>
>>I recommend SSIS highly!
>
>Naomi beat me to it!
Why are you surprised?
>>>
>>>I have a .mdb file (I guess this is an Access database) that someone sent me. I don't know the version of this Access database. I need to import it into my SQL Server 2005. I found an article on the web describing SSIS as a way to import the database. My primary concern is not to break anything in my SQL Server 2005. Is this (SSIS) method a safe and efficient method of importing Access into SQL Server? Or would you recommend another approach?
>>>
>>>TIA.
>>
>>You won't break anything in SQL Server (this ain't VFP anymore) with a SSIS import. Just make sure you import to a new database so you can look at your data once it is imported and verify you got what you think you were getting before putting it in a production database!
>>
>>I recommend SSIS highly!
>
>Naomi beat me to it!
Why are you surprised?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham