473,396 Members | 1,766 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

VB:How to import the data of a excel file to Access

Hi

I would like to develop an application in Visual Basic (both in VB.6 and
VB.NET) from where I could extract the data contained in a spreadsheet
(excel) to a Database in Access 2000.

Has anyone an idea how to do it so (which syntax to use ?)
Ed
Jul 17 '05 #1
0 4904

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Colin McNaught | last post by:
Hi, I find myself having to support a small ASP/VB/Access web application for a customer of mine. (Our main expertise is PHP/MySQL/Apache). Other than testing on the Customers ISP's Server, are...
3
by: Shapper | last post by:
Hello, I just installed Microsoft .NET Framework SDK v1.1. (http://www.microsoft.com/downloads/details.aspx?FamilyId=9B3A2CA6-3647-4070-9F41-A333C6B9181D&displaylang=en) I need to compile to a...
2
by: Kevin Gabbert | last post by:
Hiya. I'm running vb.net 2003 on a virtual machine, and I have my source files located on the network. 256 megs virtual ram, MY machine has 1,000 megs ram. however, when I work for a period...
0
by: dba123 | last post by:
In my .vb file of my VB.NET console app, I have defined several different email Functions to send out email using .NET Mail namespace and the emails are set to HTML format. In the body of them,...
2
by: Bill nguyen | last post by:
Suddenly a new file was added to forms that I created in the last 2 days. I created and named a form frmDTDownload. In Solution Explorer, now I have frmDTNDownload.vb frmDTNDownload.Designer.vb...
0
by: Elmo Watson | last post by:
I'm trying to add some code to the "MySettings_SettingsLoaded" event, in the Settings.vb file, in order to provide some dynamic content...... However, I'm running into a stumbling block - I need...
1
by: Mohsin | last post by:
Hi, any one can help me to save visual Basic Data in Access to link through Data control or ODBC. when i am trying to save vb data in Access after making link through data control it is not saving...
4
by: slinky | last post by:
I'm making a OLE DB connection in code and was wondering if anyone could identify what the syntax errors I have. I've tried countless combinations and all give errors. New...
0
by: tshad | last post by:
I have the following class in my VS 2008 Web Site project that has a namespace of MyFunctions. ********************************* Imports System Imports System.Text.RegularExpressions ...
3
by: Jerry Spence1 | last post by:
I have a project that has these files: frmCD.resx frmCD.Designer.vb frmCD.vb I had a virus which wiped out the frmCD.vb. Is it possible to regenerate it from the other files? -Jerry
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
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
0
BarryA
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...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
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...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
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...
0
tracyyun
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.