I\'m dealing with a legacy application written in VB6 which reads in Excel spreadsheets and inserts them into a database.
I maintain a .NET 3.5 application (using Visual Studio 2008) that makes a call to OleDbConnection.Open() w开发者_如何转开发ith a connection string provider of Microsoft.ACE.OLEDB.12 and an MDB file wi
Which characters need to be escaped before 开发者_高级运维being inserted into a JET Engine data table? I\'m currently just replacing the \' character for this \'\' (this are two \' characters, not a \
Has anyone successfully used a CREATE TABLE statement on an ACE OLEDB connection to an Excel 2007 workbook where the table has a hyphen in the name? What I have at the moment is something like
Does ACE OLEDB drivers have any known issues with larger files? I am using the below code to retrieve the worksheets in a 400Mb xls file
Looks like I\'m not the only one out there with this issue, but there doesn\'t seem to be an anwwer to this problem.
I\'m working on a desktop application that must support (currently) MS Access and SQL Server back ends.The application is under constant development and changes are frequently being made to the databa
I\'m handed a path of an access 2000(/2003 (edit)), or access 2007 database: C:\\database.mdb or C:\\database.accdb
I have a program in Delphi 2010 that uses a JET (mdb) database via ADO.I would开发者_如何学C like to be able to extract the definitions of some of the queries in the database and display them to the u
I\'m trying to run the code below to insert a whole lot of records (from a file with a weird file format) into my Access 2003 database from VBA.After many, many experiments, this code is the fastest I