Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > convert sql server data to msacess

Reply
Thread Tools

convert sql server data to msacess

 
 
vinodkus@gmail.com
Guest
Posts: n/a
 
      09-10-2007
dear sir/madam
How to convert sql server data to ms access.
Please help me

Thanks in advance

 
Reply With Quote
 
 
 
 
Bob Barrows [MVP]
Guest
Posts: n/a
 
      09-10-2007
http://www.velocityreviews.com/forums/(E-Mail Removed) wrote:
> dear sir/madam
> How to convert sql server data to ms access.
> Please help me
>
> Thanks in advance



This is not really a task for ASP. Access has builtin functionality for
importing data. For help, see an Access newsgroup.
SQL Server also has builting functionality for exporting data: before
SQL2005, it was called DTS (Data Transformation Services). In SQL 2005, it
is called SSIS (SQL Server Integration Services). For help with these, see
as SQL Server newsgroup.

If you insist on misusing ASP for this, then all I can say is: data is data,
no matter where it is stored. There is nothing preventing you from opening a
recordset on the SQL Server table, and using the data retrieved to build
insert statements to be executed in an Access database.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help. Getting a An error has occurred while establishing a connectionto the server. When connecting to SQL Server 2005, this failure may be causedby the fact that under the default settings SQL Server does not allow remote aboutjav.com@gmail.com ASP .Net 0 05-03-2008 12:43 PM
Do the Self-Paced Training Kits: Microsoft SQL Server 2000 include Eval copy of SQL Server? Brian Whiting Microsoft Certification 2 12-29-2005 04:24 AM
sql server express vs sql server 2000 code Daves ASP .Net 1 06-13-2005 12:24 PM
Tools to extract data from SQL database and convert it into XML & insert XML data into SQL databases Harry Zoroc XML 1 07-12-2004 10:10 PM
Can't connect to SQL Server, using Windows Authentication users of SQL server? help =?Utf-8?B?UmV6YQ==?= ASP .Net 3 06-07-2004 06:42 PM



Advertisments