importing tables from Acess to SQL

Hello
I am trying to import tables with data from Access to SQL.
The problem occures when the Primary keys and identity are not being saved
and i need to do it manually.
There is a way to import this tables with all the connection regulations
like Primary key will be saved ?
thanks
GalWe have found that the safest way to move from Access to SQL Server is to
convert the Access file to 2002, then use the Upsize Wizard to move the
schema only. Finally we use the Data Transformation Services of SQL Server
to import the data from Access.
Make sure that all the tables have a key index.
Ragnar
"'" <@.discussions.microsoft.com> wrote in message
news:B93E10E0-1C9B-4C46-83AA-32F90A07E96D@.microsoft.com...
> Hello
> I am trying to import tables with data from Access to SQL.
> The problem occures when the Primary keys and identity are not being saved
> and i need to do it manually.
> There is a way to import this tables with all the connection regulations
> like Primary key will be saved ?
> thanks
> Gal

importing tables from Acess to SQL

Hello
I am trying to import tables with data from Access to SQL.
The problem occures when the Primary keys and identity are not being saved
and i need to do it manually.
There is a way to import this tables with all the connection regulations
like Primary key will be saved ?
thanks
Gal
We have found that the safest way to move from Access to SQL Server is to
convert the Access file to 2002, then use the Upsize Wizard to move the
schema only. Finally we use the Data Transformation Services of SQL Server
to import the data from Access.
Make sure that all the tables have a key index.
Ragnar
"?" <@.discussions.microsoft.com> wrote in message
news:B93E10E0-1C9B-4C46-83AA-32F90A07E96D@.microsoft.com...
> Hello
> I am trying to import tables with data from Access to SQL.
> The problem occures when the Primary keys and identity are not being saved
> and i need to do it manually.
> There is a way to import this tables with all the connection regulations
> like Primary key will be saved ?
> thanks
> Gal

Importing an Acess database file

Hi, I'm trying to do something which should be simple but isn't wotrking for
me. I need to import an Access.mdb file into SQL Server. I don't have Access
installed on my machine, just the mdb file.
From Import data I choose Microsoft Access, browse the file, choose windows
authentication, copy tables & views , but then it doesn't give me any tables
or views to choose from, just a blank page.
Hope someone can shed some light on this.
Thanks in advance
Ant
Hi,
It might be the jet version your using.
Tyr going to Microsoft and download the lastest jet service back. Sorry I
don't have the link tyr www.microsoft.com/download and search for JET
kind regards
Greg O
Need to document your databases. Use the first and still the best AGS SQL
Scribe
http://www.ag-software.com
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:B490308C-3886-4A94-9466-4F37561E848A@.microsoft.com...
> Hi, I'm trying to do something which should be simple but isn't wotrking
> for
> me. I need to import an Access.mdb file into SQL Server. I don't have
> Access
> installed on my machine, just the mdb file.
> From Import data I choose Microsoft Access, browse the file, choose
> windows
> authentication, copy tables & views , but then it doesn't give me any
> tables
> or views to choose from, just a blank page.
> Hope someone can shed some light on this.
> Thanks in advance
> Ant
|||how ur accessing the database

Importing an Acess database file

Hi, I'm trying to do something which should be simple but isn't wotrking for
me. I need to import an Access.mdb file into SQL Server. I don't have Access
installed on my machine, just the mdb file.
From Import data I choose Microsoft Access, browse the file, choose windows
authentication, copy tables & views , but then it doesn't give me any tables
or views to choose from, just a blank page.
Hope someone can shed some light on this.
Thanks in advance
AntHi,
It might be the jet version your using.
Tyr going to Microsoft and download the lastest jet service back. Sorry I
don't have the link tyr www.microsoft.com/download and search for JET
kind regards
Greg O
Need to document your databases. Use the first and still the best AGS SQL
Scribe
http://www.ag-software.com
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:B490308C-3886-4A94-9466-4F37561E848A@.microsoft.com...
> Hi, I'm trying to do something which should be simple but isn't wotrking
> for
> me. I need to import an Access.mdb file into SQL Server. I don't have
> Access
> installed on my machine, just the mdb file.
> From Import data I choose Microsoft Access, browse the file, choose
> windows
> authentication, copy tables & views , but then it doesn't give me any
> tables
> or views to choose from, just a blank page.
> Hope someone can shed some light on this.
> Thanks in advance
> Ant|||how ur accessing the database

Importing an Acess database file

Hi, I'm trying to do something which should be simple but isn't wotrking for
me. I need to import an Access.mdb file into SQL Server. I don't have Access
installed on my machine, just the mdb file.
From Import data I choose Microsoft Access, browse the file, choose windows
authentication, copy tables & views , but then it doesn't give me any tables
or views to choose from, just a blank page.
Hope someone can shed some light on this.
Thanks in advance
AntHi,
It might be the jet version your using.
Tyr going to Microsoft and download the lastest jet service back. Sorry I
don't have the link tyr www.microsoft.com/download and search for JET
kind regards
Greg O
Need to document your databases. Use the first and still the best AGS SQL
Scribe
http://www.ag-software.com
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:B490308C-3886-4A94-9466-4F37561E848A@.microsoft.com...
> Hi, I'm trying to do something which should be simple but isn't wotrking
> for
> me. I need to import an Access.mdb file into SQL Server. I don't have
> Access
> installed on my machine, just the mdb file.
> From Import data I choose Microsoft Access, browse the file, choose
> windows
> authentication, copy tables & views , but then it doesn't give me any
> tables
> or views to choose from, just a blank page.
> Hope someone can shed some light on this.
> Thanks in advance
> Ant|||how ur accessing the database