Transfer a Text file to MS Access table

  • Thread starter Thread starter Burt Rosner
  • Start date Start date
B

Burt Rosner

To anyone,

I'm trying to 1) select a Text File(.txt), 2) Move it to
a MS Access table.

I looked at ASPUpLoad and thought there was a cheaper and
simplier way of doing it. Would anyone have additional
input on either a software package I can purchase, or ASP
commands I might use.

Thanks, in advance, for your help.

Burt
 
What is it that you are trying to accomplish, importing the text file
content into a record or the storage of actual file in a single field?

If it is the importing of the content, then you are going to have custom
write a ASP script using the FileSystemObject to open and read the text
file, and then import it.

If it is the storage of the actual file, then a component like ASPUpload
would be needed, but it will depend on what you host has installed or is
willing to install on their server.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
Thomas,

Thanks.

I want to bring the content of the file into a MS Access
Table then dissect it into data fields. The dissecting I
have down pretty good. I've done it in other programs. I
just have not done it in ASP VBScript before and not
familiar with the command needed to get the text file into
a MS Access Table.

Thanks again,

Burt
 
Burt,

Ok, you need to study up on the FileSystemObject, to open the file, then
parse the individual fields, then loop through the parsed content and then
write the individual records to the database, then close the text file and
the database, etc.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
Thomas,

Getting on it right now.

Thanks for pointing me in the right direction,

Burt
 
Back
Top