I created simple form now I want to submit on access

Question

2.00/5 (1 vote)

See more:

I created Simple form with 4 text box (NAME,Phone Number, Email,Remark)
and also create 2 button save and clear now clear working but when I want to save this data on access 2007 so what to do any ? if possible let me know with out coding if possible ...

Posted 18-Oct-12 8:57am

vijay thakkar

Add a Solution

Comments

Sergey Alexandrovich Kryukov 18-Oct-12 15:03pm

First of all, you need to tag the application type (Forms, WPF, ASP.NET, etc...), or explain what do you mean by "Form", exactly.
--SA

vijay thakkar 18-Oct-12 15:06pm

vb.net

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sergey Alexandrovich Kryukov · Answer 1 · 2012-10-18T09:09:00

You need to use Office Excel Interop assembly, which you can reference by your application through "Add Reference" (Solution Explorer context menu item, and then the window), from tab ".NET", because this assembly is put in GAC.

One of the huge number of articles which could walk you through this is this one, from CodeProject:
Export to Excel using VB.Net[^].

But this question is way too redundant. Do you think CodeProject don't have search capability? Think again:
http://www.codeproject.com/search.aspx?doctypeid=1&q=Access+VB.NET[^].

This question in not completely incorrect, but can be greatly improved. You should have re-formulated it:

"How to use Wikipedia, Google, Bing, CodeProject and StackOverflow.com?"

If you asked and got good Answers, the Questions like your original one would not be needed!

Good luck,

—SA

Maciej Los · Answer 2 · 2012-10-18T09:50:00

Solution 2

Sergey's answer is very good!

Here is the collection of few useful links:
http://msdn.microsoft.com/en-us/library/ms971485.aspx[^] - recommended!
http://connectionstrings.com/[^]
Using ADO.NET for beginners[^]

Posted 18-Oct-12 9:50am

Maciej Los

Comments

Sergey Alexandrovich Kryukov 18-Oct-12 15:54pm

Good point. I forgot to mention ADO.NET. I usually gladly recommend the article you referenced. Well, my 5.
--SA

Maciej Los 18-Oct-12 15:56pm

Thank you, Sergey ;)

Espen Harlinn 18-Oct-12 18:44pm

5'ed!

Maciej Los 19-Oct-12 2:13am

Thank you, Espen.