I have a Dataset that contains 10-12 tables. I want to export that dataset to Access in .Net Core but facing some issue. Can anyone please help me on that.
I had tried to use OleDbConnection but getting the error like System.Data.Oledb is not supported on this platform. Also tried to use OdbcConnection but getting the same error like System.Data.Odbc is not supported on this platform. Although I found some suggestion to degrade the framework but It's not possible for me to degrade the framework as it is going to effect other functionality in the project. The .Net Framework I am using is 5.0.
sunil mohantyPosted Sep 20, 2023, 7:52 AM
The SP is returning 5-6 tables. The Dataset will contain those tables. What are the tables there on the dataset I need to create those tables in MSAccess.This is not a one-time conversion. The conversion is basically depends upon the enduser. In the UI when the enduser select "Export to Access " then internally one SP will be called that will return multiple tables and output should be a MS Access file with those tables.
Sam HobbsPosted Sep 20, 2023, 12:16 AM
Is the dataset a database or something else? What is the database or whatever that you need to export?
Is this a one-time conversion or do you need to do it more than once, such as monthly or daily? Is there a reason you cannot use a utility instead of developing a C# program?