I cannot import the data from the Access database in Visual Studio community

Question

I cannot import the data from the Access database in Visual Studio community

Kenrick77 1

Hi Experts,
I connected the database to the Visual Studio. However, I just cannot import the data or columns into the form in Visual Studio, I attached a photo, please help me ,thanks.

PengGe-MSFT 3,381 Reputation points

2021-08-18T06:57:28.787+00:00

Hi, @Kenrick77
Since your issue is more related to office-access-dev, I'll help you add the office-access-dev tag so that engineers from the VS team could check your issue.

5 answers

Your answer

PengGe-MSFT 3,381 Reputation points

2021-08-18T06:57:28.787+00:00

Hi, @Kenrick77
Since your issue is more related to office-access-dev, I'll help you add the office-access-dev tag so that engineers from the VS team could check your issue.

Answer 1

The picture doesn't really help us. The Server Explorer UI just allows you to visualize data without using something like SSMS. It has nothing to do with your projects. To connect to the DB in your app you need the connection string, your app must be x86 (or Any CPU with Prefer 32-bit code enabled) so that it will use the Access DB driver and then you can load the data.

In your screenshot there isn't any DataGridView or anything to actually load the data so we'll need to see how you're loading the data, if you are at all. If you aren't yet loading data then of course there isn't anything to do yet.

Answer 2

Kenrick77 1

I could connect just now and I cannot now again. I encounter one more error which is this' The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.' It keeps coming back to me no matter which solution I applied.

Answer 3

This is a bitness issue then most likely. That driver is installed for x86 but not x64. It'll work in VS which is an x86 app but won't work in an x64 app. In your application settings what platform are you targeting? If you are targeting 'Any CPU' then you need to ensure that the Prefer 32-bit option is checked in your project's Build properties. You'll then be targeting x86 even on an x64 OS. Alternatively if you only support Access then change your app's platform to x86 so it always runs in this mode.

Answer 4

Kenrick77 1

Hi, how come my Visual Studio doesn't have data binding?

Michael Taylor 60,161 Reputation points

2021-08-18T13:34:12.247+00:00

What do you mean you don't have data binding? As I already mentioned you haven't data bound anything in the sample you've shown. Server Explorer has absolutely nothing to do with data binding or your projects. It is simply a simple UI for viewing data when you don't have SSMS or equivalent tools available. It is completely unrelated to any projects you may have, is a VS only thing, and has nothing to do with data binding.

To data bind you need a project that supports it (like Winforms or WPF) and you need controls added to your project that support data binding (such as a DataGridView). You haven't provided us any information on your project information as was requested earlier. Refer to articles on data binding such as this to explain how data binding works and note that Server Explorer is not relevant for this discussion.

Answer 5

Kenrick77 1

I solved already and I encountered one new error which is I cannot save data to the Access database,please see the attached photo.

Michael Taylor 60,161 Reputation points

2021-08-18T14:51:47.913+00:00

This is a separate question related to how you're binding and what data technology you're using. Please post as a new question.

Share via

I cannot import the data from the Access database in Visual Studio community

5 answers

Your answer