The easiest way to transport data from MsSql --> Access is through the import functionality of access.
You might be able to do this trough Access OLE automation. Another way would be to create insert statements from the MsSql database but this would be quite a bit harder, because you would also need to build the DB schema information and convert the columns. Data only it is quite doable. ----- Original Message ----- From: "pinky p" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, September 12, 2005 10:04 AM Subject: Re: [AspNetAnyQuestionIsOk] Database BackUp > thank u .... Mischa... > i have 1 more request .... > > now currently i m workin on MS SQL Server > and want 2 Export data from SQL Sever to Access > > i want 2 do through my application. > Do anybody have the code(asp.net) for this situiation? > > Thanks in Advance > > --- Mischa Kroon <[EMAIL PROTECTED]> wrote: > > > --------------------------------- > In query analyzer type backup and look it up in books > online for a more > advanced overview. > > > The short answer... > > From sql books online: > > -- Back up the full MyNwind database. > BACKUP DATABASE MyNwind TO MyNwind_2 > > -- Update activity has occurred since the full > database backup. > > -- Back up the log of the MyNwind database. > BACKUP LOG MyNwind > TO MyNwindLog1 > > > > ----- Original Message ----- > From: "pinky p" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Monday, September 12, 2005 5:56 AM > Subject: Re: [AspNetAnyQuestionIsOk] Database BackUp > > >> Hi >> Wanted a code which can take a BackUp of a > particular >> database. >> Database = SQL Server 2000 >> >> Thanks in Advance >> >> >> >> >> >> >> >> >> > ______________________________________________________ >> Yahoo! for Good >> Watch the Hurricane Katrina Shelter From The Storm > concert >> http://advision.webevents.yahoo.com/shelter >> >> >> >> >> >> Yahoo! Groups Links >> >> >> >> >> >> > > > > --------------------------------- > YAHOO! GROUPS LINKS > > > Visit your group "AspNetAnyQuestionIsOk" on the > web. > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! > Terms of Service. > > > --------------------------------- > > > > > > > > ______________________________________________________ > Yahoo! for Good > Donate to the Hurricane Katrina relief effort. > http://store.yahoo.com/redcross-donate3/ > > > > > > Yahoo! Groups Links > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
