need to save this data to either a database (access or oracle) or spreadsheet (excel)

[Mohsin]

Hi there (Greetings)
I am constructing some forms on which data will be entered. I need to
save this data to either a database (access or oracle) or spreadsheet
(excel)
so that it can be stored and referred to for future use.

I will then also need to call back some of this data to the visual
basic
form so that further data can be added to the original entires and
resaved.

my question is very obvious and hope that that expert will succor me
regarding said matter . please help me for aforesiad.

how will i make link between visual Basic form and access, oracle and
excel and how will i save this.

thanks in advance .

regards
Mohsin

 

[Arvin Meyer [MVP]]

You can do it with any of the methods. Using Excel might be easier if you
were not using a form, and you had flat data (a simple list) instead of
relational data. Oracle is a server based database, so you'll need
connection to the server or a copy of the data. It can be made the most
secure, if that is a requirement.

The Access engine can be used either on a server or on a stand-alone
machine. For me, Access or Excel would be the choice depending upon whether
the data was a simple list or not.
--
Arvin Meyer, MCP, MVP
Microsoft Access
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Smartin]

Hi there (Greetings)
I am constructing some forms on which data will be entered. I need to
save this data to either a database (access or oracle) or spreadsheet
(excel)
so that it can be stored and referred to for future use.

I will then also need to call back some of this data to the visual
basic
form so that further data can be added to the original entires and
resaved.

my question is very obvious and hope that that expert will succor me
regarding said matter . please help me for aforesiad.

how will i make link between visual Basic form and access, oracle and
excel and how will i save this.

thanks in advance .

regards
Mohsin

Hello

It seems you have asked a few questions similar to this so I am
wondering if you are aware that Access makes the process of linking a
form (user interface) to data (in a table) very simple.

You have mentioned Visual Basic more than once -- are you using a
stand-alone Visual Basic product? While you may have particular reasons
for doing so I think it bears repeating that Access provides a very
straightforward way to do what you are asking.

The process is simple:

1. Create a new access database

2. Create your table(s), or link to existing table(s). Access gives you
a lot of flexibility here -- you can link to Access tables, Oracle, SQL
Server, spreadsheets, and a number of others.

3. Create your form and bind it to the appropriate table or query. By
default, Access will allow you to add or update information using the
form, and it is automatically saved in the table.

Hope this helps.

 

['69 Camaro]

Hi, Mohsin.

my question is very obvious

You have asked very politely several times, and the answers you have received
expect you to have a very basic understanding of the tools you are using. You
haven't had the training, so you may not understand the advice you have been
given. Until you get that training from a course, a tutor, a book, or online
research, I suggest you post your question in one or both of the following
newsgroups and ask for step-by-step guidance:

http://groups.google.com/group/microsoft.public.vb.general.discussion?hl=en

http://groups.google.com/group/microsoft.public.vb.database?hl=en

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.