Tagged Questions
0
votes
0answers
20 views
How to export an SDF-file to an Excel file (xls or xlsx) through c#?
I have an question,
How do I export an SDF database to an excel file?
Thanks!
0
votes
2answers
32 views
Compare column names in excel sheet with column names in a table in SQL
I have an excel sheet a large number of columns (~500) and a DB table with similar number of columns. I can run SQL queries on the database. What I want to achieve is to find the columns that are in ...
0
votes
0answers
30 views
Embedded Excel spreadsheet that is populated by SQL statements using a database
I am about to start a project at work and I am leaning in the direction of just creating a webpage to be uploaded to our apache server with an embeded excel document that will be populated by SQL ...
2
votes
2answers
63 views
SQL Searching a String for Numbers between different criteria
I have been attempting this issue for a while and have yet to find a solution.
I am looking for a method using SQL commands to Search a String for an alphanumeric number between 2 points.
For ...
0
votes
0answers
14 views
Data format management framework
The application I'm working on outputs data in a number of different contexts. HTML, PDF, Excel, JavaScript, and SQL primarily. Most of these have their own way of specifying a display format for a ...
0
votes
0answers
28 views
update table from excel file MySql
update initl
set initl.High=Exc.High
from INITLIMITS as initl
INNER JOIN OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\Users\nkavroulakis\Downloads\nikos\excel ...
1
vote
1answer
62 views
Firebird - How to use “(? is null)” for selecting blank parameters
I am working with an Excel Report linked to a Firebird 2.0 DB and I have various parameters linked to cell references that correspond to drop down lists.
If a parameter is left blank, I want to ...
0
votes
0answers
16 views
Toad export different language
i really hope that someone can help me.
I'm trying to export a query results to excel file via toad,
but the problem is that the export to the file is not showing the correct text of my language..
but ...
0
votes
0answers
28 views
Create a connection to an informix DB using ODBC and parameters through Excel VBA
For reasons out of my control I cannot use Microsoft Query and parameters for this, as would be desirable, so I wish to go through this route, but I'm not sure how.
Using VBA, I want to establish a ...
1
vote
3answers
69 views
Using the '?' Parameter in SQL LIKE Statement
Beginner question here...
I am accessing a Firebird Database through Microsoft Query in Excel.
I have a parameter field in Excel that contains a 4 digit number. One of my DB tables has a column ...
1
vote
0answers
40 views
Passing parameters through Excel to an Informix DB works through MS Query but fails when returned to Excel due to General Error
I require to query an informix database using parameters and Excel. When the query is executed in Microsoft Query the dataset is fetched and returned succesfully, when I attempt to return to Excel the ...
0
votes
2answers
47 views
Data from excel to sql tabel is importing in NULL values…why??
I am importing data from excel to database.
Following is schema of excel columns:
below is the schema of db....and exactly matches with excel sheet data....................
ID integer ...
0
votes
2answers
38 views
Prevent Excel from Changing Text to Number [closed]
I am trying to write an sql script to populate a database using Excel [OP is trying to use Excel to compose a valid SQL statement], it is working perfect with one exception. I need to enter the dates ...
0
votes
1answer
61 views
Data Access in exporting SQL to table to Excel from VB
given the code , the error that is showing is "Type 'DataAccess' is not defined"
:
Protected Sub ExportPOS(ByVal sender As Object, ByVal e As DirectEventArgs) Handles ExportButton.Click
...
10
votes
4answers
13k views
Excel function to make SQL-like queries on worksheet data?
I have a largish table in an excel worksheet:
Column_1 | Column_2 | Column_3
ValueA ValueB ValueC
....
What I need is a function that will take as input the range and an SQL-like query ...
