How to save an Excel range into an Access Database

B

Belinda

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
 
O

onedaywhen

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!
 
B

Belinda

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!
Click to expand...

Many thanks for the feedback.

I want to save a range.

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

Thanks
Belinda
 
Top