I would like to push a button on my VB6 program that will
automatically export data from my SQL server database table "Raw Data"
into an Access Database Table called "Raw Data1".

I am very new at SQL server and VB6 so I need step by step
instructions on how to do this?

---

Request for Question Clarification by answerguru-ga on 12 Mar 2005 17:05 PST

Hello jstm-ga,

A common way of achieving what I think you're trying to do is linking
the two tables (one in Access and the other in SQL Server). This way
you are able to obtain current data whenever the Access table is used.
A major assumption here is that the SQL Server from which you are
obtaining this source data will actually be available to you
continuously. Is this the case?

Thanks,
answerguru-ga

---

Clarification of Question by jstm-ga on 12 Mar 2005 17:12 PST

Yes, I think so. When the user enters data (VB6) it goes into the SQL
Server database. However, I would like to use Access to generate
reports so I need to get the data from SQL Server into Microsoft
Access. I need the data to be readily available real-time...

---

Clarification of Question by jstm-ga on 12 Mar 2005 17:41 PST

I got the information but you put it in the wrong question...

I already have the SQL table set up and the Access table which are
both identical in field names, etc. In other words the Access table is
a mirror of the table inside SQL server.

Given that, where to I begin reading (start) with your answer? (I'm a
little confused)

---

Clarification of Question by jstm-ga on 12 Mar 2005 17:47 PST

Also, to add to my other question. When I export the data from SQL
into Access will it write over the already existing data if it is
dulpicate records?

I hope so because I will be exporting from SQL to Access very
frequently and I don't want to end of with dulpicate records?

---

Request for Question Clarification by answerguru-ga on 12 Mar 2005 17:58 PST

To answer your question, when you link a SQL Server table to Access,
it reflects the source table exactly. So no, there are no duplicates.

Also, I just wanted to make sure that you are aware that another user
posted the comment in the other question, not me. You can identify
offical GA researchers as their nicknames are links. Regular users
also cannot officially answer questions.

I will go ahead and answer this question using the linked tables approach.

answerguru-ga

---

Request for Question Clarification by answerguru-ga on 12 Mar 2005 18:05 PST

I noticed that a solution to this was posted in your other question -
if that works for you, you may want to expire this question.

---

Clarification of Question by jstm-ga on 12 Mar 2005 18:14 PST

Thanks answerguru-ga! It works fine...I hope you did not have to much
work in this already!

Actually, if you're running SQL Server 2000 and have access to the
VS.NET 2003 dev environment, I would consider using Reporting
Services.  It's got more to offer than Access does.  It's a web
application, is free with your license of SQL Server, and offers
security directly in the web interface for NT Authentication.  If that
can work for your environment, it's worth checking out.  This
eliminates the need for all clients to have a copy of Access and also
allows easy exporting into other formats.  I've also used it to push
reports to people or groups on a regular basis.  Some of those reports
have a link to more details if the user wants to see them.

I believe the web site is www.microsoft.com/sql/reporting, but I may
be off a bit.  The SQL site will definitely have link of some sort.