Jesus
|
| Posted: 11/11/2005, 5:20 AM |
|
Hello,
There is an example in this foro to import data from excel to SQL db from ASP code.
I try to modify it for ACCESS but does not work. Please, any one have an easy example to do that?
Thanks in advance.
|
|
|
 |
swapkum
|
| Posted: 11/21/2005, 7:21 PM |
|
send me the code.
|
|
|
|
Edd
Posts: 547
|
| Posted: 11/21/2005, 9:25 PM |
|
If you are loading spreadsheets all the time I would suggest a couple of alternatives
1. Get ADO to read the spreadsheet - there are a number of articles in this forum on the subject. This can get messy and you will need to be an advanced programmer.
OR
2. http://www.findy.com/doc_xlintro.asp
Cut and paste facility but requires a COM object.
OR
3. As I have done, adapted Excel as HTML lookalike spreadsheets then get the data back directly into database. This method is preferable as you ensure that the cells are what they are supposed to be.
There are a number of these on the market. I used:
http://www.spreadsheetconverter.com/Default.htm
You will need to be reasonably advanced in your ASP code to master this but the benefits are worth the effort.
Regards
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
 |
|
|
