Home
Forums
Programming
Web Development
Tutorials
Snippets
Blogs
Freelance
Jobs
Lounge
Login
Join for Free!
Programming Help
C and C++
Visual Basic
Java
VB.NET
C#
ASP.NET
PHP
ColdFusion
Perl and Python
Ruby
Databases
Other Languages
Game Programming
Software Development
Computer Science
Industry News
Web Development
Web Development
HTML & CSS
JavaScript
Graphic Design
Flash & ActionScript
Blogging
SEO & Advertising
Web Servers & Hosting
Site Check
What's Here?
Members:
149,946
Replies:
507,370
Topics:
79,977
Snippets:
2,668
Tutorials:
705
Total Online:
1,390
Members:
78
Guests:
1,312
[X]
My Assistant
Loading. Please Wait...
Dream.In.Code
>
Programming Help
>
Visual Basic
Welcome to Dream.In.Code
Become a VB Expert!
Join 149,946 VB Programmers for FREE!
Get instant access to thousands
of VB experts, tutorials, code snippets, and more! There are 1,390 people online right now.
Registration is fast and FREE...
Join Now!
Chat
LIVE
With a VB Expert
how to open, and paste the data of an excel file using ado code
how to open, and paste the data of an excel file using ado code
Options
ricky_martin
11 Jan, 2008 - 02:55 AM
Post
#1
New D.I.C Head
Joined:
10 Jan, 2008
Posts:
2
hi frdz
i am new to vb prgming n wann ur help
Issue: import data from an Excel sheet into a database on vb form.
1. I used common dialog control to open the excel file bt dont know hw to import data on form n save it in access db.
kindly help
This Post Was Helpful!
Register for Free to Make These Ads Go Away!
Nayana
RE: How To Open, And Paste The Data Of An Excel File Using Ado Code
14 Jan, 2008 - 08:09 PM
Post
#2
DIC Hawk - 나야나 नयन:
Joined:
14 Nov, 2007
Posts:
824
Thanked:
5 times
Dream Kudos:
175
My Contributions
First give it a try, then post your code, and someone'll (probably) help you from there.
For a start, you can use ODBC drivers to access the data.
This post has been edited by
Nayana
: 14 Jan, 2008 - 08:22 PM
This Post Was Helpful!
Display Mode:
Standard
·
Switch to: Linear+
·
Switch to: Outline
Track this topic
·
Email this topic
·
Print this topic
·
Subscribe to this forum
Time is now: 1/8/09 05:11PM
Invision Power Board
v2.1.7 © 2009 IPS, Inc.
Licensed to: MediaGroup1
Advertising
|
Terms of Use
|
Privacy Policy
|
About Us
|
Site Map
Forum Index:
Programming Help
|
C and C++
|
Visual Basic
|
Java
|
VB.NET
|
C#
|
ASP.NET
|
PHP
|
ColdFusion
|
Perl and Python
|
Ruby
|
Databases
|
Other Languages
|
Game Programming
|
Software Development
|
Computer Science
|
Industry News
|
Programming Tutorials
|
C++ Tutorials
|
Visual Basic Tutorials
|
Java Tutorials
|
VB.NET Tutorials
|
C# Tutorials
|
Linux Tutorials
|
PHP Tutorials
|
ColdFusion Tutorials
|
Windows Tutorials
|
HTML/JavaScript Tutorials
|
CSS Tutorials
|
Flash Tutorials
|
Web Promotion Tutorials
|
Photoshop Tutorials
|
Software Development Tutorials
|
Database Tutorials
|
Other Language Tutorials
|
ASP.NET Tutorials
|
Copyright 2001-2008
MediaGroup1 LLC
, All Rights Reserved
A
MediaGroup1 LLC
Production - Version 6.0.2.1.36
Server: secure2
Search
Updated!
w00t
Over 509,000 Pages!
Advanced Forum Search
Be Social
Live VB Help!
VB Tutorials
Visual Basic 6 Library Functions – String Type
Visual Basic 6 Quick Reference (Cheat Sheet)
File Handling in Visual Basic 6 Part 1 - Sequential Files
Visual Basic 6 Library Functions – Numeric Type
Connecting to a SQL Server database using ADODB
Resize Form & Controls For Screen Size - VB6
DISASSEMBLING VISUAL BASIC APPLICATIONS
Visual Basic 6 -Determining Each Character in VB
Non-Repeating Random Numbers
VB Data Controls and usage.
35 More VB Tutorials...
Reference Sheets
VB Snippets
Reading a Text file Line by Line
Shutdown Computer from VB
RoundUp and RoundDown functions in VB 6.0
Open & Saving .txt files
Starting an *.exe file from VB6 code
calculator
Analog Clock
Open/Close your CD-Drive.
Open/Close your CD-Drive door.
TextBox Telephone Number Formatting
111 More VB Snippets...
DIC Chatroom
Join our IRC Chat
Bye Bye Ads
Monthly Drawing
Top Contributors
Top 10 Kudos This Month
girasquid
(75)
AdamSpeight2008
(75)
kryton46
(50)
Barnz
(50)
DillonSalsman
(50)
jacobjordan
(50)
~NJ
(25)
snoj
(25)
KYA
(25)
gothik12
(25)