Import Excel to Access via ASP

Import Excel to Access via ASP

am 27.02.2005 18:53:09 von jake

Can anyone point me to code examples or tutorials on importing Excel date
into an Access database using ASP?

Thanks!

Re: Import Excel to Access via ASP

am 28.02.2005 03:44:57 von McKirahan

"Jake" wrote in message
news:#GkdtUPHFHA.3076@tk2msftngp13.phx.gbl...
> Can anyone point me to code examples or tutorials on importing Excel date
> into an Access database using ASP?
>
> Thanks!

Have you tried a Google search?

Techniques for successfully importing Excel data into Access
http://techrepublic.com.com/5100-6270_11-5276622.html

Re: Import Excel to Access via ASP

am 28.02.2005 08:59:53 von jake

Yes I have and found nothing.

The link you provided is for import functions using the Windows
applications.
I need to do with is ASP - hence the post to this group :-)



"McKirahan" wrote in message
news:DeGdnXiWc7q0GL_fRVn-gA@comcast.com...
> "Jake" wrote in message
> news:#GkdtUPHFHA.3076@tk2msftngp13.phx.gbl...
>> Can anyone point me to code examples or tutorials on importing Excel date
>> into an Access database using ASP?
>>
>> Thanks!
>
> Have you tried a Google search?
>
> Techniques for successfully importing Excel data into Access
> http://techrepublic.com.com/5100-6270_11-5276622.html
>
>
>

Re: Import Excel to Access via ASP

am 28.02.2005 16:57:27 von McKirahan

"Jake" wrote in message
news:uhWi3tWHFHA.4060@TK2MSFTNGP14.phx.gbl...
> Yes I have and found nothing.
>
> The link you provided is for import functions using the Windows
> applications.
> I need to do with is ASP - hence the post to this group :-)
>
>
>
> "McKirahan" wrote in message
> news:DeGdnXiWc7q0GL_fRVn-gA@comcast.com...
> > "Jake" wrote in message
> > news:#GkdtUPHFHA.3076@tk2msftngp13.phx.gbl...
> >> Can anyone point me to code examples or tutorials on importing Excel
date
> >> into an Access database using ASP?
> >>
> >> Thanks!
> >
> > Have you tried a Google search?
> >
> > Techniques for successfully importing Excel data into Access
> > http://techrepublic.com.com/5100-6270_11-5276622.html

I didn't read the article; I just posted it as an example of what a Google
search will reveal. There's even more when you search under Google Groups.

More details would help. Do the MS-Excel and MS-Access files reside on the
server? In the same folder? What version are they? How many record/fields
are we talking? To use MS-Access it must be available; it is installed on
the server in an accesssible path or is it on the client?

BTW, I presume you're interested in "importing Excel data" not in "importing
Excel date".

Also, please do not top post.

Re: Import Excel to Access via ASP

am 03.03.2005 02:19:15 von Bullschmidt

You can connect to a csv file (which can be opened in Excel and which an
Excel file can be converted into) in good form just as you can to a
regular database.

The .csv file needs to be uploaded to the server.

And you can have two recordsets open at the same time.

So I'd suggest going through this recordset one row at a time and within
this loop add a new record to the "real" database's recordset.

And for help connecting to a text file using the Jet OLE DB provider:
http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Pro viders.htm#O
LEDBProviderForMicrosoftJetText

And based on the above link realize that the actual filename does NOT go
in the connection string - rather it goes in the SQL statement
(definitely a little tricky).

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!