Skip to main content
13 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
1 answer
214 views

On our dev environment we have MS Office 365 32-bit version on Windows 11 64-bit and Visual Studio 2022 with SSDT. The issue we are experiencing is in SSIS when creating Excel Destination in order to ...
ausmod's user avatar
  • 71
1 vote
0 answers
129 views

I have a server that has Microsoft Access Database Engine (2010) installed. We use this library in C# to process really large files (read), the other libraries mentioned below don't work (they run out ...
Bhanu Prakash's user avatar
  • 11
0 votes
0 answers
384 views

In the older version(.NET Framework) of my desktop application, I used Entity Framework to connect my Access Database to my application and generated code files from .edmx. Now I'm migrating it to ....
Tinu_Thomas's user avatar
  • 1
0 votes
0 answers
467 views

I have read myself in circles for days prior to posting this question, including all AI engines. Pardon this post again. I am looking for a fresh perspective. I have this powershell script that works ...
coffeeANDVolts's user avatar
  • 45
-1 votes
2 answers
112 views

I have two column one is Address ID and another one is Customer Name. below table is for reference 0608 Internet company 3623 Authority 3623 Authority 5478 Group Holdings (Pty) Ltd. 5478 Shankara 5478 ...
yogesh sk's user avatar
  • 1
1 vote
0 answers
106 views

I was going through July 5, 2022, update for Office 2016 (KB5002226) and I found that the file identifier and file name are different in the case of Acacedao.dll under the file information section. ...
Fatima Ali's user avatar
  • 41
0 votes
1 answer
3k views

We're running SQL Server 2014 with all the latest service packs. Our users heavily rely on OPENROWSET for importing XLSX, CSV and TXT files. Example: SELECT * FROM OPENROWSET ('MSDASQL','DRIVER={...
Depth of Field's user avatar
  • 337
1 vote
1 answer
272 views

I am attempting to migrate a number of stored procedures, which insert to Microsoft Access 2002-2003 format database files, as linked servers. The process is currently working fine on the following ...
Matt's user avatar
  • 23
0 votes
1 answer
310 views

Can some one please help me to resolve the issue ? I am getting the syntax error while running this code. OleDbConnection cn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=J:...
Hariharan Haridoss's user avatar
  • 1
1 vote
2 answers
2k views

So I'm setting up a dataflow to pull data from an Access DB and into my Datafactory and then pushing to the lake/datawarehouses. I've set up an integration runtime on the VM that has the file on it. I'...
Benjamin Bingham's user avatar
  • 87
0 votes
1 answer
643 views

I'm trying to pull data out of a Microsoft Access Database. The access database seems to be used by others, and isn't owned by me/my team. I'm purely taking data out, so the user I'm setting up ...
Benjamin Bingham's user avatar
  • 87
0 votes
0 answers
147 views

1-Hi Sir, I have Table of General in Access Database when I make the entry like Sale and purchases payment Receipt How I bound two column (Debit and Credit) must equal than save the entry I connected ...
Imtiaz's user avatar
  • 1
0 votes
0 answers
628 views

I started a new job with a brand new laptop and vanilla environment. I have installed Visual Studio and I'm trying to convert a XLS file to TXT. This is my Control Flow: And this is my Data Flow: ...
Francesco Mantovani's user avatar
  • 12.8k