469,576 Members | 1,677 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,576 developers. It's quick & easy.

SQL, VB and Access

Hi all,
I would like to find out about a Microsoft Access database that was
"converted" to SQL.
Not sure what that means, and would appreciate anyone letting me know.
I'm at the intermediate level with Access and have some VB experience, but
not SQL.
I would like to extract the data from the SQL converted database and burn
it onto a CD. What would be the best method to do this?

Thanks for any advice or direction.

Mark
Nov 13 '05 #1
3 1141
In message <GA******************@newssvr13.news.prodigy.com >, Mark T.
<tu**********@sbcglobal.net> writes
Hi all,
I would like to find out about a Microsoft Access database that was
"converted" to SQL.
Not sure what that means, and would appreciate anyone letting me know.
I'm at the intermediate level with Access and have some VB experience, but
not SQL.
I would like to extract the data from the SQL converted database and burn
it onto a CD. What would be the best method to do this?


My guess is that the database was upsized to SQL Server. That meansd
that the data is no longer held in the Access database file but is
instead held in a separate database which may be on a different machine
on a network. That database may have security restrictions that prevent
you from accessing the data.

If you open the Access database file and look at the tables you will
probably see that some of the database names have an arrow symbol that
indicates a linked table rather than a table held in the Access file.
You can open these in Access and export the data in a variety of
different formats, select Export from the file menu.

Access databases are often upsized when they need to handle large
amounts of data. You may find that there is more data than will fit on a
CD.


--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

Nov 13 '05 #2
Thanks for the SQL / VB / Access information.
I'll be able to use that to accomplish what I need to do.

Mark
Nov 13 '05 #3
There's no way to know exactly that means, but it probably means that it
was converted to a SQL Server database. If it's an "Access" database,
then it uses Jet as the DB engine and Jet is a SQL DB.

As for extracting and burning the data onto a CD, Access can export data
into various kinds of formats (including XML for the more recent
versions). All you need to do is figure out what data you need in what
form.

Hope that helps,

Carlos

Mark T. wrote:
Hi all,
I would like to find out about a Microsoft Access database that was
"converted" to SQL.
Not sure what that means, and would appreciate anyone letting me know.
I'm at the intermediate level with Access and have some VB experience, but
not SQL.
I would like to extract the data from the SQL converted database and burn
it onto a CD. What would be the best method to do this?

Thanks for any advice or direction.

Mark

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

63 posts views Thread by Jerome | last post: by
13 posts views Thread by Simon Bailey | last post: by
reply views Thread by Frederick Noronha \(FN\) | last post: by
64 posts views Thread by John | last post: by
17 posts views Thread by Mell via AccessMonster.com | last post: by
37 posts views Thread by jasmith | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.