473,326 Members | 2,127 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,326 software developers and data experts.

how to get data from excelsheet in vb application

how to check whether it is excelsheet or not and how to get data from sheet ie., how to read data from the path of file(ecxel sheet)

i can wriite query like

select * from [sheet1$]

but i require data from any sheet with out knowing name of excel sheet i have to get data from that path
like
read.path format



pls anyone can u send me the code....its urgent
Jun 9 '07 #1
0 1037

Sign in to post your reply or Sign up for a free account.

Similar topics

8
by: harry | last post by:
Hi Folks: I'm trying to do something that looks simple, but I can't make it work right. It's Access 2000 on a Win2000 computer. I create a database with 5 columbs. The data I need to import...
1
by: Ramakrishnan Nagarajan | last post by:
Hi, I am converting Excel data into a Dataset in C#. There are around 24 columns in the Excel Sheet. First I tried to insert one row with correct values in the Excel sheet. i.e. for text columns...
1
by: vijay | last post by:
HI All, I want to print excelsheet from my application i am working on C#.net windows application . pls help me
2
by: manssi | last post by:
hii, i have created a macro in excel in windows vista and its running there perfectly and now i want to run this macro from a form in asp.net. how can i do this? actually my application...
22
by: DThreadgill | last post by:
Hi all - having a bit of problem with this code. It works in one of the databases that I have but not the one I'm currently working with...I've compared references and they're both the same: When...
1
by: jayakumarmaarga | last post by:
Hi, How to open Password Protected Excelsheet, I know password and i want to open that excelsheet by given this password and read the excelsheet values again post values to sql database.
0
by: progvar | last post by:
Hi actually i want to confirm can i transfer this table data into excel after this query which you gave me . I mean i want to show this table data into excelsheet i use this method but it shows...
2
mageswar005
by: mageswar005 | last post by:
hi, I need one help, How can i Export the Datas from mysql to Excelsheet not csv in php coding.The excelsheet format should be comes under microsoft office excel spreadsheet format.i need all...
6
by: sachinkale123 | last post by:
I am working on an application Where I want to import data from Excelsheet to Dataset. But While doing that i am facing following problems: 1) When I close excelsheet and try to import data from...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.