Import / Export Data within Access & SQL

[gstylianou]

Hello to all,

Because this issue is something I haven't addressed, I would like to ask if an access form can have RecordSource directly from an external SQL file. For your best understanding on what i'm trying to do, please note know the following

There is an SQL database on the same computer as my Access database in which (SQL) there is data uploaded from a web site to the internet. I want to import those data into my own database which will then be displayed in forms.

Moreover i would like to ask if it's possible to extract data from my MSAccess direct into SQL database

Any help, point of view is important and thank you in advance

 

[Minty]

You can link a SQL database table directly to an access database.
You can read and write directly to a linked SQL table.

Does that help?

 

[gstylianou]

You can link a SQL database table directly to an access database.
You can read and write directly to a linked SQL table.

Does that help?

Thanks, i will make some testings

 

[Minty]

Be aware that you/ your users will need the appropriate permissions on the SQL tables / views to be able to read or write to them.

 

[theDBguy]

And if you have data in an Access table and want to export them to SQL Server, that is possible too.

 

[gstylianou]

And if you have data in an Access table and want to export them to SQL Server, that is possible too.

Ηι,

How can i do this "theDBguy" ? Could you please give me some details?

Thanks again

 

[theDBguy]

Ηι,

How can i do this "theDBguy" ? Could you please give me some details?

Thanks again

Hi. For example, if you have a DSN connection created for the SQL Server database, you can right-click on the Table you want to export and select Export > ODBC Database. Hope it helps...