convert sql server data to msacess

vinodkus

dear sir/madam
How to convert sql server data to ms access.
Please help me

Thanks in advance

Sep 10 '07 #1

Subscribe Post Reply

2688

Bob Barrows [MVP]

vi******@gmail.com 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"

Sep 10 '07 #2

by: SD | last post by:

Hi, This is driving me nuts, I have a table that stores notes regarding an operation in an IMAGE data type field in MS SQL Server 2000. I can read and write no problem using Access using the...

Microsoft SQL Server

How to Convert text list into 2d array

by: Andrew V. Romero | last post by:

At work we have an excel file that contains the list of medications and their corresponding strengths. I would like to save the excel file as a text list and paste this list into a javascript...

Javascript

Convert an Access database to SQL

by: cory | last post by:

Hi, I have an Access database and am having an ASP.NEt application written for it. It is almost complete. I have a hosting company that I signed up with a month ago but before I did anything I...

Microsoft Access / VBA

how to create database in mssql server

by: Nanda | last post by:

hi, how to create database in mssql server using c#. We can create msacess database using adox, similiarly how to create sql server database using c#. Regards, Nanda.

C# / C Sharp

how to read/write MSAcess mdb ???

by: saduns | last post by:

how can i work on MSAcess with C++ ????

.NET Framework

Retriving the last row in a MSACESS table

by: LM | last post by:

Hello, Is it possible to get only the last row of a table (MSACESS) without have to load the complete table? Thank´s in advance. L. Mendes

Visual Basic .NET

Need Help... Convert VB.NET to C#

by: manmit.walia | last post by:

Hello All, I am stuck on a conversion problem. I am trying to convert my application which is written in VB.NET to C# because the project I am working on currently is being written in C#. I tried...

C# / C Sharp

How much to convert to SQL server

by: Jan | last post by:

Hi: I have an Access database that's been running (in one form or another) for a couple of different clients for a few years. Now a new client has requested that it be implemented with a SQL...

Microsoft Access / VBA

How do I convert my dates to string in ADO

by: tshad | last post by:

Apparently, I can't do: Dim da2 As New OleDb.OleDbDataAdapter("Select PR, Convert(varchar,getchar(),1),F1, F2, F5, Sum(F4) from temp .... I am getting this error. 'undefined function...

ASP.NET

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

Similar topics