jet

相关标签：javascript jquery android 多少钱 iPhone

IIf function inside Access query

I have a query and I would like to use an IIf function as part of the criteria.Here is the full SQL: SELECT Hits.HitID, Hits.ListingID, Hits.HitCount, Hits.HitDate, Hits.HitTypeID, Hits.开发者_如何转[详细]

2023-01-21 18:38 分类：问答
Cannot read Excel files in SSIS 2008

I\'m stuck trying to get SSIS 2008 to read an Excel file. Yesterday, I migrated our SSIS project from 2005 to 2008, and though the upgrade said it worked, I cannot get it to read an Excel file.I read[详细]

2023-01-21 14:01 分类：问答
SQL CE vs Jet in winforms application

I have a legacy desktop application using JET for the database.The application needs to be a开发者_如何学Cble to access the database file from a network drive.Should I migrate the data access to SQL C[详细]

2023-01-20 04:21 分类：问答
Using Access 2003 VBA functions through JET

Hallo all. 开发者_运维知识库I need to run the \'replace([column], [new], [old])\' in a query executing on n Access 2003 DB. I know of all the equivalent stuff i could use in SQL, and believe me I wo[详细]

2023-01-20 01:37 分类：问答
JET SQL Performance/ SQL Understanding

This is not a problem that needs answering, more of a query on why this is happening. I have a field in one table that is populated with \'Y\' Or \'N\', and i have a query that simply takes the value[详细]

2023-01-16 18:40 分类：问答
I need a workaround for Excel Guessing Data Types problem

I\'m creating a utility to import data from Excel to Oracle database, I have a fixed template for the excel file,[详细]

2023-01-13 07:29 分类：问答
JETCOMP.EXE arguments

I want to compact an access MDB database file using JetComp.exe . I want to pass the name of the file ( and the destination file) to Jetcomp.exe . However, JetComp.exe does not seem to respond. I trie[详细]

2023-01-13 02:53 分类：问答
Database advice needed: porting VB6/ADO/JET app to VB.NET

I need to update (well, rewrite really) a SMALL VB6 application which uses ADO to access a JET database, to a vb.net app in Visual Studio 2008.[详细]

2023-01-08 04:01 分类：问答
Getting around the lack of a Left Trim(string, char[]) function in JET / Access

I need to remove leading zeros from a string field in an Access database that is destroyed and recreated every time it is used within a C# program. Most string libraries (even SQL ones) include a Trim[详细]

2023-01-05 21:45 分类：问答
VB6: what is the likely cause of Error 3078 " ... Jet database engine cannot find the input table or query ... "

VB6: what is the likely cause of Error 30开发者_如何学C78 \" ... Jet database engine cannot find the input table or query ... \"A typo in the table name.Try checking the connection and checking the da[详细]

2023-01-04 21:26 分类：问答