All Questions
71 questions
0
votes
0
answers
47
views
How can I change the command text of an SQL connected table in Excel using VBA? [duplicate]
Our company has a lot of macros in VBA. We are trying to replace some of it with RPA etc, but there are alot and some development on them is therefore required.
In certain cases we have macros that ...
- 56
0
votes
1
answer
68
views
My excel report takes long time to generate
In My project I have SQL and Excel report,we need to generate report for every Four Hours. We have following Issue.
The Four Hours data - 30,000 Rows with 7 Column in SQL DATABSE , By using current ...
0
votes
1
answer
591
views
How do I write data from access tables to excel
I am looping through a table called _TF_Tables which contains the names of all tables within the database for which an Excel workbook needs to be created and filled with data from that table.
The ...
- 832
0
votes
1
answer
109
views
Export specific column values in excel to datagrid using VB.Net
How to export particular column values which does not have header to datagrid
...
dta = New OleDbDataAdapter("Select * from [linexcel$])
...
How can I specify the column(column B and D) instead ...
- 27
1
vote
1
answer
187
views
Excel to DataTable importing wrong values
I'm developing a program that will import excel to mysql. In the application, the user first of all has to load an excel file and then he will see that file load on a DataGridView.
The problem is ...
- 4,367
0
votes
0
answers
61
views
Generating Excel Sheet Crash
I have a Function that query dataBase and constructs excel file. However I run into this crash when I click into Excel when the data is not done importing. Beside the click everything works perfect.
...
user9469222
-1
votes
1
answer
75
views
Odd errors with connecting to AD - visual basic
Have couple of odd issues. I connect to AD to get the list of active users and their groups and write it out into the table in SQL. Code is written in Visual Basic. Occasionally I would get an error "...
- 43
0
votes
0
answers
153
views
Pull in Data from a SQL Table into Excel using VBA and a Data Validation Box
I have code that is pulling in data from a SQL table, and using VB and a data validation List Box that allows the user to select a criteria then it should pull in the data associated with that ...
- 3
0
votes
2
answers
336
views
How can I convert multiple raw values in single column
My data is like this:
But I want to arrange all raw value in one column for a single mobile number like this:
0
votes
1
answer
2k
views
Using WHERE SQL Command in Excel using VB.Net
I am having difficulty in constructing SQL Commands in VB.Net wherein my project is connected to Excel via OLEDB.
Select * From [Sheet$]
This SQL Command works but whenever I try to add another SQL ...
- 61
0
votes
1
answer
153
views
Create table from Excel file
I'm trying to create a temp table on my database from an Excel file uploaded by the user. I cannot understand where is the problem and why Visual Studio is throwing that exception.
Code
Private ...
- 953
0
votes
1
answer
1k
views
select multiple column from excel in VBA
How can I select multiple column in Excel file using Vba. because I have excel file contains 580 columns.
I try using Query below, but its only can select 255 columns.
Dim ExcelConnection As New ...
- 118
0
votes
3
answers
260
views
How can I combine two excel columns during import to a database?
I am trying to combine a date and time columns in excel and map it to one column in a database using sqlbulkcopy. I am getting an error:
Date][time does not match any column mapping
See my sample ...
- 31
0
votes
0
answers
45
views
Not proper in column when importing csv file into datagridview
I have problem when importing csv file into datagridview. It is not in proper column in only add column.
Here is the code:
Try
Dim conn As System.Data.OleDb.OleDbConnection
Dim ds ...
1
vote
2
answers
166
views
Importing Excel data into SQL Server database
I want to import Excel chart into my SQL Server database by select it by dialog box and automatically save it to the SQL Server table + I want to generate the record ID by the sub that I made.
The ...
- 23