Click here to Skip to main content
15,898,538 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Number Format Localization Pin
Shameel10-Aug-11 22:52
professionalShameel10-Aug-11 22:52 
QuestionUpdate Query Error Pin
Gagan.2010-Aug-11 7:12
Gagan.2010-Aug-11 7:12 
AnswerRe: Update Query Error Pin
Simon_Whale10-Aug-11 7:57
Simon_Whale10-Aug-11 7:57 
AnswerRe: Update Query Error Pin
Luc Pattyn10-Aug-11 8:48
sitebuilderLuc Pattyn10-Aug-11 8:48 
AnswerRe: Update Query Error Pin
Shameel10-Aug-11 8:58
professionalShameel10-Aug-11 8:58 
GeneralRe: Update Query Error Pin
Gagan.2011-Aug-11 3:16
Gagan.2011-Aug-11 3:16 
GeneralRe: Update Query Error Pin
Shameel11-Aug-11 5:03
professionalShameel11-Aug-11 5:03 
QuestionNeed help with advanced manipulation of Excel files using VB.NET Pin
User 76894779-Aug-11 19:07
User 76894779-Aug-11 19:07 
Hi,

I'm developing a VB.NET application that manipulates 6 Excel files and genetates one sinle Excel file using data stored in those 6 files. This is needed to make my job easier.

I'm assuming those excel files as database tables, and in order to create my final excel (like View/Query in databases) i need to get data from each of the excel files (like taking maching columns OR joins).

The way I want to implement the application is: taking each excel files from OpenFileDialogs in VB, running SQL queries on those excel files, and generating the necessary excel file by a single button click.

I think I could explain the case well and you understand everything with the situation..

Now, the question is:

1. Can I run sql queries on excel columns?

2. Wouldn't it be too slow if I have 63000 rows in some of my excel files?

3. If yes, can you give me some code samples to run SQL Queries on two (already exist) excel files and generating the third-one based on these files (like what we do in database views)?


Your help will be really appreciated!!!

thx.

modified 6-Oct-18 21:01pm.

AnswerRe: Need help with advanced manipulation of Excel files using VB.NET Pin
Suresh Suthar9-Aug-11 19:13
professionalSuresh Suthar9-Aug-11 19:13 
GeneralRe: Need help with advanced manipulation of Excel files using VB.NET Pin
User 76894779-Aug-11 19:54
User 76894779-Aug-11 19:54 
GeneralRe: Need help with advanced manipulation of Excel files using VB.NET Pin
Andy_L_J9-Aug-11 20:13
Andy_L_J9-Aug-11 20:13 
GeneralRe: Need help with advanced manipulation of Excel files using VB.NET Pin
dan!sh 9-Aug-11 20:25
professional dan!sh 9-Aug-11 20:25 
GeneralRe: Need help with advanced manipulation of Excel files using VB.NET Pin
Andy_L_J9-Aug-11 21:07
Andy_L_J9-Aug-11 21:07 
QuestionVista\Win7 - Is it possible to shell and specify an account to run the process under? Pin
Jon_Boy9-Aug-11 3:11
Jon_Boy9-Aug-11 3:11 
AnswerRe: Vista\Win7 - Is it possible to shell and specify an account to run the process under? Pin
Shameel9-Aug-11 4:44
professionalShameel9-Aug-11 4:44 
GeneralRe: Vista\Win7 - Is it possible to shell and specify an account to run the process under? Pin
Jon_Boy10-Aug-11 6:42
Jon_Boy10-Aug-11 6:42 
GeneralRe: Vista\Win7 - Is it possible to shell and specify an account to run the process under? Pin
MicroVirus10-Aug-11 7:58
MicroVirus10-Aug-11 7:58 
QuestionComboBox DisplayMember and ValueMember without database Pin
ivo755-Aug-11 7:13
ivo755-Aug-11 7:13 
AnswerRe: ComboBox DisplayMember and ValueMember without database Pin
ivo755-Aug-11 8:09
ivo755-Aug-11 8:09 
AnswerRe: ComboBox DisplayMember and ValueMember without database Pin
Luc Pattyn5-Aug-11 9:53
sitebuilderLuc Pattyn5-Aug-11 9:53 
GeneralRe: ComboBox DisplayMember and ValueMember without database Pin
ivo755-Aug-11 11:38
ivo755-Aug-11 11:38 
GeneralRe: ComboBox DisplayMember and ValueMember without database Pin
Andy_L_J5-Aug-11 17:37
Andy_L_J5-Aug-11 17:37 
QuestionReleasing a VB application for use in a Win PE Pin
Slingshot II5-Aug-11 4:00
Slingshot II5-Aug-11 4:00 
AnswerRe: Releasing a VB application for use in a Win PE Pin
Shameel5-Aug-11 4:19
professionalShameel5-Aug-11 4:19 
AnswerRe: Releasing a VB application for use in a Win PE Pin
Eddy Vluggen5-Aug-11 6:16
professionalEddy Vluggen5-Aug-11 6:16 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.