How to convert MS access database SQL server database ?

[asdf]

First create duplicate table structures in SQLServer. Then you can:

1. Link these tables into your MSAccess database and create append queries
to append the information to the new SQLServer tables. or

2. Export your data as ascii text and use the BCP utility to load into
SQLServer.

Terence <tre...@pl.jaring.my> wrote in article
<6g5i98$k...@news2.jaring.my>...
> Hi there ,
>
> Anyone have tried converting MS Access database to SQL server Database ?
All
> my OCBC intranet connection are done through MS Access . However , we
have
> currently shifted to SQL server . Can some tell me how to do this ?
>
> Thank you so much ,
>
> Regards ,
> Terence
>
>
>

[Lianne Hargreaves]

I think there must be an easier way than this. My husband transferred a
little database I have from Access into SQL Server and he didn't have to set
up table structures, etc first. I think he must have found some kind of
Export/Import function.

Rgds
Lianne

asdf wrote in message <01bd6010$91436be0$89ca06d0@KGBHome95>...

[Terence]

[Bernd Wolff]

tre...@pl.jaring.my meinte am 05.04.98
zum Thema "How to convert MS access database SQL server database ?":

> Hi there ,
>
> Anyone have tried converting MS Access database to SQL server Database ? All
> my OCBC intranet connection are done through MS Access . However , we have
> currently shifted to SQL server . Can some tell me how to do this ?

Try the upsizing tools from the MS web page.

Bernd
-------------------------------------------------------------------------
This line intentionally left blank
## CrossPoint v3.1 ##

[Neil Pike]

Terence,

MS has free Access->SQL Server upsizing tools on it's website/

Neil Pike MVP/MCSE
Protech Computing Ltd