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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment