sql to excel to access database

[ExcelTom]

I am bringing in an odbc connection to excel. I brought the table into excel without problem, but if a file gets changed in the database will it reflect in excel? And if I move the excel sheet over to an access database will that also see any changes made?

I am using office 2013.

Thanks, for any help.

 

[ExcelGuyDude]

When you hit the refresh button, the Excel information will reflect all the correct changes that have occurred within the database. As for the Access Database, depending on the method you use for moving the information over, the Access table will contain the most recent information that's been reported in Excel (as long as the Access to Excel connection is still good).

 

[ExcelTom]

Alright, thanks.