Working with text database in an asp page?

[dothvader]

I am trying to work with a coma-delimited text database in an asp
page. The text database will be uploaded to the server every day. I
have worked with asp code and and an access database (mdb file) and
know how that works.

My question is:

How does one move the text database into the access datbase
automatically?

or

Is there a way to write asp code code to work directly with the text
database?

 

[Stefan B Rusynko]

To read the text see
http://www.w3schools.com/asp/asp_ref_textstream.asp

IMHO
- just use a DB which can also be updated daily

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I am trying to work with a coma-delimited text database in an asp
| page. The text database will be uploaded to the server every day. I
| have worked with asp code and and an access database (mdb file) and
| know how that works.
|
| My question is:
|
| How does one move the text database into the access datbase
| automatically?
|
| or
|
| Is there a way to write asp code code to work directly with the text
| database?
|

 

[OShea]

The Data Results Wizard can do this for you. Just create a new database
connection, choose browse and change file type to Text.

Some may tell you not to use a text file, but I've done it countless times
with spreadsheets and never had a single issue.

 

[dothvader]

The Data Results Wizard can do this for you. Just create a new database
connection, choose browse and change file type to Text.

Some may tell you not to use a text file, but I've done it countless times
with spreadsheets and never had a single issue.

The Data Results Wizard asks for a schema.ini file. I have tried to
figure out how to create it either from excel or access and can't seem
to find it out. I know I could create it from scratch but there has
to be an automatic way when you export the file.

Any help?

 

[Thomas A. Rowe]

You need to ask your question in either the Excel or Access newsgroups.


If you have Access, then why not use Access database as the data source?
--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

 

[dothvader]

You need to ask your question in either the Excel or Access newsgroups.

If you have Access, then why not use Access database as the data source?
--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

I would love to use a mdb file but I am receiving this as text
database from another source direct to my server.