How can I transfer Data From Access?

18 Mar 2006 5:22 PM

needin4mation

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.

18 Mar 2006 6:00 PM

Sue Hoegemeier

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, needin4mat***@gmail.com
wrote:

Show quoteHide quote

>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.

18 Mar 2006 6:09 PM

Jens

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
---

19 Mar 2006 1:08 AM

needin4mation

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.

19 Mar 2006 2:09 AM

Roger Wolter[MSFT]

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

<needin4mat***@gmail.com> wrote in message

Show quoteHide quote

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.
>