| Groups | Blog | Home |
sql server new users : How to transfer data from SQL Server 2000 to MS Access
Hi there: We're in the middle of getting rid of small and meaningless
databases but I need to move some of them from SQL Server to Access. Considering that I'm a newbie, wich is the better way to do this.? How I can move all the information from our SQL Server to Access..? Any help will be appreciated. TIA and best regards
Hi Mike thanks for the quick response is just that I have been there, done
that. When I specify Microsoft Access as my destination a message saying: Could not open the specified file for reading. Make sure that the file exists, and you have read access to it. Correct me please if I'm wrong, but this operation should create a new .mdb file. Am I right.? Thanks Adrian Inzunza [quoted text, click to view] "Mike Epprecht (SQL MVP)" wrote:
> Hi > > Use DTS a.k.a SQL Server "Import and Export Data" from the SQL Server Start > Menu > > The source is SQL Server, the destination is Access. > > Regards > -------------------------------- > Mike Epprecht, Microsoft SQL Server MVP > Zurich, Switzerland > > IM: mike@epprecht.net > > MVP Program: http://www.microsoft.com/mvp > > Blog: http://www.msmvps.com/epprecht/ > > "Adrian Inzunza" <Adrian Inzunza@discussions.microsoft.com> wrote in message > news:C718FB30-3786-43AC-80BF-7F29F3E265AD@microsoft.com... > > Hi there: We're in the middle of getting rid of small and meaningless > > databases but I need to move some of them from SQL Server to Access. > > Considering that I'm a newbie, wich is the better way to do this.? How I > > can > > move all the information from our SQL Server to Access..? > > > > Any help will be appreciated. > > > > TIA and best regards > > > > Adrian Inzunza > >
Done
Mike,thanks for your help. Once I generated the .mdb file I was be able to export the data. cheers Adrian Inzunza [quoted text, click to view] "Mike Epprecht (SQL MVP)" wrote:
> Hi > > No. Create an Empty DB though Access and use that. SQL Server does not > provide the Access Engine that is required to create the DB, just the > Drivers to be able to consume an Access DB. > > Regards > -------------------------------- > Mike Epprecht, Microsoft SQL Server MVP > Zurich, Switzerland > > IM: mike@epprecht.net > > MVP Program: http://www.microsoft.com/mvp > > Blog: http://www.msmvps.com/epprecht/ > > "Adrian Inzunza" <AdrianInzunza@discussions.microsoft.com> wrote in message > news:868B71DF-406A-4D92-B462-5B8654EE98B2@microsoft.com... > > Hi Mike thanks for the quick response is just that I have been there, done > > that. When I specify Microsoft Access as my destination a message saying: > > Could not open the specified file for reading. Make sure that the file > > exists, and you have read access to it. > > > > Correct me please if I'm wrong, but this operation should create a new > > .mdb > > file. Am I right.? > > > > Thanks > > > > Adrian Inzunza > > > > "Mike Epprecht (SQL MVP)" wrote: > > > >> Hi > >> > >> Use DTS a.k.a SQL Server "Import and Export Data" from the SQL Server > >> Start > >> Menu > >> > >> The source is SQL Server, the destination is Access. > >> > >> Regards > >> -------------------------------- > >> Mike Epprecht, Microsoft SQL Server MVP > >> Zurich, Switzerland > >> > >> IM: mike@epprecht.net > >> > >> MVP Program: http://www.microsoft.com/mvp > >> > >> Blog: http://www.msmvps.com/epprecht/ > >> > >> "Adrian Inzunza" <Adrian Inzunza@discussions.microsoft.com> wrote in > >> message > >> news:C718FB30-3786-43AC-80BF-7F29F3E265AD@microsoft.com... > >> > Hi there: We're in the middle of getting rid of small and meaningless > >> > databases but I need to move some of them from SQL Server to Access. > >> > Considering that I'm a newbie, wich is the better way to do this.? How > >> > I > >> > can > >> > move all the information from our SQL Server to Access..? > >> > > >> > Any help will be appreciated. > >> > > >> > TIA and best regards > >> > > >> > Adrian Inzunza > >> > >> > >> > >
Hi
Use DTS a.k.a SQL Server "Import and Export Data" from the SQL Server Start Menu The source is SQL Server, the destination is Access. Regards -------------------------------- Mike Epprecht, Microsoft SQL Server MVP Zurich, Switzerland IM: mike@epprecht.net MVP Program: http://www.microsoft.com/mvp Blog: http://www.msmvps.com/epprecht/ [quoted text, click to view] "Adrian Inzunza" <Adrian Inzunza@discussions.microsoft.com> wrote in message news:C718FB30-3786-43AC-80BF-7F29F3E265AD@microsoft.com... > Hi there: We're in the middle of getting rid of small and meaningless > databases but I need to move some of them from SQL Server to Access. > Considering that I'm a newbie, wich is the better way to do this.? How I > can > move all the information from our SQL Server to Access..? > > Any help will be appreciated. > > TIA and best regards > > Adrian Inzunza
Hi
No. Create an Empty DB though Access and use that. SQL Server does not provide the Access Engine that is required to create the DB, just the Drivers to be able to consume an Access DB. Regards -------------------------------- Mike Epprecht, Microsoft SQL Server MVP Zurich, Switzerland IM: mike@epprecht.net MVP Program: http://www.microsoft.com/mvp Blog: http://www.msmvps.com/epprecht/ [quoted text, click to view] "Adrian Inzunza" <AdrianInzunza@discussions.microsoft.com> wrote in message news:868B71DF-406A-4D92-B462-5B8654EE98B2@microsoft.com... > Hi Mike thanks for the quick response is just that I have been there, done > that. When I specify Microsoft Access as my destination a message saying: > Could not open the specified file for reading. Make sure that the file > exists, and you have read access to it. > > Correct me please if I'm wrong, but this operation should create a new > .mdb > file. Am I right.? > > Thanks > > Adrian Inzunza > > "Mike Epprecht (SQL MVP)" wrote: > >> Hi >> >> Use DTS a.k.a SQL Server "Import and Export Data" from the SQL Server >> Start >> Menu >> >> The source is SQL Server, the destination is Access. >> >> Regards >> -------------------------------- >> Mike Epprecht, Microsoft SQL Server MVP >> Zurich, Switzerland >> >> IM: mike@epprecht.net >> >> MVP Program: http://www.microsoft.com/mvp >> >> Blog: http://www.msmvps.com/epprecht/ >> >> "Adrian Inzunza" <Adrian Inzunza@discussions.microsoft.com> wrote in >> message >> news:C718FB30-3786-43AC-80BF-7F29F3E265AD@microsoft.com... >> > Hi there: We're in the middle of getting rid of small and meaningless >> > databases but I need to move some of them from SQL Server to Access. >> > Considering that I'm a newbie, wich is the better way to do this.? How >> > I >> > can >> > move all the information from our SQL Server to Access..? >> > >> > Any help will be appreciated. >> > >> > TIA and best regards >> > >> > Adrian Inzunza >> >> >>
Don't see what you're looking for? Try a search.
|
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |