How to save an Excel range into an Access Database

  • Thread starter Thread starter Belinda
  • Start date Start date
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
 
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!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to pass an Excel range as an argument to a SQL Server stored Procedure 7
auto populate access database from an excel form 1
Error Message - Macro to Unlink MS Queries from Workbook 0
Getting information from access table in excel 1
What are the steps to fix damaged MDF files in SQL Server? 0
How to copy data from an excel cell into a field in access table 0
How to find the range of a web query on a Excel worksheet 3
Running an Access function (with parameters) from Excel 6

Back
Top