FrontPage Programming - Working with text database in an asp page?

Author

Working with text database in an asp page?

dothvader

2007-02-07, 10:15 pm

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

2007-02-08, 6:15 am

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!" (-;
_____________________________________________

"dothvader" <mark@trekwest.com> wrote in message news:1170897674.186940.246650@m58g2000cwm.googlegroups.com...
|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

2007-02-08, 6:16 pm

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" wrote:

> 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?
>
>

dothvader

2007-02-23, 10:15 pm

On Feb 8, 10:33 am, OShea <O...@discussions.microsoft.com> wrote:[color=darkred]
> 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" wrote:
>
>
>
>

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

2007-02-24, 6:20 pm

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" <mark@trekwest.com> wrote in message
news:1172286275.260650.106340@j27g2000cwj.googlegroups.com...
> On Feb 8, 10:33 am, OShea <O...@discussions.microsoft.com> wrote:
>
> 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?
>

dothvader

2007-02-26, 6:16 pm

On Feb 24, 12:22 pm, "Thomas A. Rowe" <tar...@mvps.org> wrote:[color=darkred]
> 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" <m...@trekwest.com> wrote in message
>
> news:1172286275.260650.106340@j27g2000cwj.googlegroups.com...
>
>
>
>
>
>
>
>
>

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