Stack Overflow
Stack Overflow

Questions tagged [jet]

Jet is the SQL database engine used by Microsoft Windows. It is also used by Microsoft Access. For Java Emitter Templates, see `java-emitter-templates` and `eclipse-jet`

Microsoft Jet is a SQL database engine that is used by the Microsoft Windows operating system.

It is an embedded database engine: just a library of functions used by applications that need SQL-based database functionality, with databases just being files on disk; just like SQLite or FireBird.

Jet databases usually have the extension .mdb. They are commonly known as Microsoft Access databases. This is because Microsoft Access, an application that provides a GUI frontend for creating and querying SQL-based databases, has always used Jet as its default database engine, and it is the de facto standard for examining the contents of an existing Jet database. However, Access can easily connect to other types of databases, and Jet databases can easily be used from other applications.

The latest version of Jet, used in Windows 7, is 4.0; the latest version of Access no longer uses Jet, but a successor with a different name, ACE.

For Java Emitter Templates, see

577 questions
0
votes
1 answer

How to SQL-query this excel table with accented names of the columns in header?

Summary: Using the Jet.OLEDB provider and the SQL query, I cannot extract some columns from the Excel table. The reason probably is that the header text contains some accented characters. Is it possible to refer the columns technically? Something…
pepr
  • 20,112
  • 15
  • 76
  • 139
0
votes
1 answer

Error '80004005' only when SELECT DISTINCT with ASP Classic

I am developing in ASP VBScript at work and need to run a SELECT DISTINCT query but I am having some troubles. I have other queries in my code that work perfectly fine, that do not use SELECT DISTINCT. Here is what I am using: Dim…
beyondit01
  • 37
  • 7
0
votes
1 answer

Connection String Help Microsoft Jet 4.0 Paradox

I am trying to connect to a server in PowerPivot. I am running across a few problems. Here is the connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\accounting001\Accounting\TimeSlips2014\Databases\Philadelphia\;Extended…
Jason Grass
  • 1
  • 1
0
votes
3 answers

Help with this JET Sql Query

I need help to do this query select. for example I have these fields: idInvoice date amount Depending of the date I need multiply the field "amount" for x number or other one. For example, if the date is less 01/01/2010 to multiply for 20 . But…
aco
  • 819
  • 4
  • 15
  • 32
0
votes
2 answers

combine 2 sql select count statements

I ahave 2 simple count queries: select count (*) from t_object select count (*) from t_diagram How is the simplest way to combine their result (sum)?
user3165438
  • 2,631
  • 7
  • 34
  • 54
0
votes
1 answer

Relational database schema: multiple contributor tables, multiple contribution tables

I'm working on a constituent relationship management system in Microsoft Access 2007. We have two types of contributors each with their own tables: The table Constituents, which has individual people with names and ages and a bunch of foreign keys…
Ain Britain
  • 370
  • 4
  • 15
0
votes
3 answers

syntax error while inserting data into ms access table

I have a following code: OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=storage_db.accdb"); string sql = "INSERT INTO Client…
user3340565
  • 45
  • 1
  • 7
0
votes
2 answers

Select elements from XML using Xpath

I have a huge XML file. Looks somthing like the following ... ... ... ... ...…
607-GXF
  • 9
  • 3
0
votes
1 answer

SQL: Select Character between Multiple Known Strings

I only want to select characters found between parentheses "()" I found code that will select characters between the same string: Public Function GetStuffYouWant(ByVal pInput As Variant, _ Optional pSplitChar As String = "-") As Variant …
user4581436
  • 47
  • 2
  • 11
0
votes
0 answers

Trying to replace c# code having oledbadaptor, Microsoft.Jet.OLEDB.4.0

Below is the source from an old environment and I need to deploy this in new windows server 2014. I initially thought of deploying the code AS IS but later I thought about Microsoft.Jet.oledb support options in the coming years and hence decided to…
Anirudh
  • 581
  • 5
  • 14
  • 32
0
votes
1 answer

Getting unspecified error while Reading CSV file using OleDbDataAdapter

Update 1 : I think schema.ini is incorrect. Please refer to below question. The file (dsTextFile) has just one row of data but record count is zero. So it means it is not reading at all. This is with removing FMT altogether or with Delimi. I still…
Anirudh
  • 581
  • 5
  • 14
  • 32
0
votes
3 answers

The INSERT INTO statement contains the following unknown field name: 'NoName'

The INSERT INTO statement contains the following unknown field name: 'NoName'. Make sure you have typed the name correctly, and try the operation again. That is the error thrown when I try to insert a record into a dbase file (.dbf) from a .Net…
David Jiboye
  • 511
  • 8
  • 19
0
votes
1 answer

Connection String to use Microsoft Text Driver with a preconfigured data source name

We are currently using the following connection string in a script to read a CSV via the Microsoft Text Driver: myConn.ConnectionString= "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=O:\;Extensions=asc,csv,tab,txt;" Instead of specifying the…
slayernoah
  • 4,382
  • 11
  • 42
  • 73
0
votes
0 answers

PHP - readable date from negative long timestamp with custom base year

I've seen a number of questions and answers on StackOverflow covering the scenario where timestamps have been based on the Unix Epoch but have been struggling to combine the solutions and modify them into a working solution for the data and custom…
richhallstoke
  • 1,519
  • 2
  • 16
  • 29
0
votes
1 answer

Syntax while trying to include The multi-part identifier [°C] in command text

I am trying to copy data directly from a Microsoft Excel file into the database using Asp.net. The problem is that the spreadsheet has a column named Product[°C], which, when I include in the query, fails to parse as valid SQL. I'm using the…
b k
  • 199
  • 1
  • 10
1 2 3
…
38 39