ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to save an Excel range into an Access Database (https://www.excelbanter.com/excel-programming/293398-how-save-excel-range-into-access-database.html)

Belinda

How to save an Excel range into an Access Database
 
Our users want the Excel range to be saved into a Access database. Can
you kindly provide some code fragments that can do this.

Thanks
Belinda

onedaywhen

How to save an Excel range into an Access Database
 
The Range object or the data it holds? Save once and archive or save
on demand? To a new table or an existing one? Does the data have a
key? ...? ...?

If you don't provide more details you'll only get Andy Wiggins'
standard issue advert!

--

(Belinda) wrote in message om...
Our users want the Excel range to be saved into a Access database. Can
you kindly provide some code fragments that can do this.

Thanks
Belinda


Belinda

How to save an Excel range into an Access Database
 
(onedaywhen) wrote in message . com...
The Range object or the data it holds? Save once and archive or save
on demand? To a new table or an existing one? Does the data have a
key? ...? ...?

If you don't provide more details you'll only get Andy Wiggins'
standard issue advert!


Many thanks for the feedback.

I want to save a range.

It will be save once to a new database and table.

Thanks
Belinda


All times are GMT +1. The time now is 01:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com