DECLARE @PATH NVARCHAR(1000) = N'\\MY-SERVER\C$\Folder\\' DECLARE @TABLE NVARCHAR(50) = SUBSTRING(@FILENAME,0,CHARINDEX('.',@FILENAME)) DECLARE @SQL NVARCHAR(4000) = N'IF OBJECT_ID(''dbo.' + @TAB...

I am trying to extract the schema of an .mdb database, so that I can recreate the database elsewhere. How can I pull off something like this?

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 in Access 2010, using a linked table to an SQL Server 2005 database (...

I received an error while trying to execute an MS SSIS package that contained Excel source: "The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine". While trying to ins...

I'm trying to read Excel spreadsheets with a 64bit Process. Therefore I use the 64 bit Version of Micorosft Access Database Engine 2010. The following code var cs = @"Provider=Microsoft.ACE.OLEDB...

I am experiencing a timeout issue writing data from a dataset into an excel spreadsheet. Here is my connection string currently: <add key="ExcelConnectionStringHeader" value="Provider=Microsoft...

We know the MS Access database engine is 'throttled' to allow a maximum file size of 2GB (or perhaps internally wired to be limited to fewer than some power of 2 of 4KB data pages). But what does t...

I have 2 tables AP and INV where both have the columns [PROJECT] and [Value]. I want a query to return something like this : PROJECT | SUM_AP | SUM_INV I came up with the code below but it's ret...

I'm trying to import an 82k+ row table from an access db to SQL Server 2008. Using the SQL Server Import and Export Wizard, I get an error at about 78k records entered. Here's the error: Error 0...

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 fastes...

For a small project I need to utilize a simple database with very light requirements: few tables, no more than few thousands of records in total, 2 or 3 users. I am working in .NET environment. As...

I asked a question a while ago about which local DB was right for my situation. I needed to access the DB from both .NET code and VB6. The overwhelming response was SQLite. However, I decided to pa...

I'm looking for a Delphi component / library to open and read from an mdb (MS Access) database. I will not be writing to the db or displaying the data; just need to read the db using whatever...

What is the proper multi-character wildcard in the LIKE operator in Microsoft Jet and what setting affects it (if any)? I am supporting an old ASP application which runs on Microsoft Jet (on an Acc...

How to read (and write) MS Access files (.mdb) in Java? Is there any open-source jdbc driver for MS Access?

My project that I am working on is almost finished. I am loading a .MDB file, displaying the contents on a DataGrid and attempting to get those changes on the DataGrid and save them back into the ....