How can I transfer Data From Access?

Hi, I have an Access 97 Database. I have Visual Studio 2005. Can I
use VS 2005 To upload data from Access 97 to my SQL Server database? I
tried the upsizing wizard for Access 97, but it just gives an error
"Overflow." If I can't use Access, is there anyway to import a CSV set
of data into my SQL Server using the SQL Server manager tools?
Thank you for any help.Refer to the following:
ACC97: "Overflow" Error Message When You Try to Upsize to
SQL Server 2000
http://support.microsoft.com/?id=279454
You can import CSV files into SQL Server using Data
Transformation Services (DTS).
-Sue
On 18 Mar 2006 09:22:09 -0800, needin4mation@.gmail.com
wrote:
>Hi, I have an Access 97 Database. I have Visual Studio 2005. Can I
>use VS 2005 To upload data from Access 97 to my SQL Server database? I
>tried the upsizing wizard for Access 97, but it just gives an error
>"Overflow." If I can't use Access, is there anyway to import a CSV set
>of data into my SQL Server using the SQL Server manager tools?
>Thank you for any help.|||Hi there,
would be nice to know which version of SQL Server you are using. But
you can use the DTS Wizard from SQL Server to import the data from
Access to the database.
HTH; Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||Jens wrote:
> Hi there,
> would be nice to know which version of SQL Server you are using. But
> you can use the DTS Wizard from SQL Server to import the data from
> Access to the database.
> HTH; Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
Thank you. I will try that (SQL Server Express 2005). I found also
that I could right click on the table and export to ODBC datasource.|||Then stick with the Export option. DTS isn't part of SQL Express.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
<needin4mation@.gmail.com> wrote in message
news:1142730485.100766.246270@.u72g2000cwu.googlegroups.com...
> Jens wrote:
>> Hi there,
>> would be nice to know which version of SQL Server you are using. But
>> you can use the DTS Wizard from SQL Server to import the data from
>> Access to the database.
>> HTH; Jens Suessmeyer.
>> --
>> http://www.sqlserver2005.de
>> --
> Thank you. I will try that (SQL Server Express 2005). I found also
> that I could right click on the table and export to ODBC datasource.
>