Re: Working with text database in an asp page?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Feb 24, 12:22 pm, "Thomas A. Rowe" <tar...@xxxxxxxx> wrote:
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...@xxxxxxxxxxxx> wrote in message

news:1172286275.260650.106340@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

On Feb 8, 10:33 am, OShea <O...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
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?

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?

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

.

Relevant Pages

  • Re: Dynamic DataSource paths?
    ... Create your Word doc and save it in the same folder as the mdb file. ... and save the data source as.odc in the same folder as ... Word's support of relative file paths is limited, ... I want to distribute the Database with the Microsoft Word Mail Merge. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Last Record
    ... By the way, the data source is an Access database, and the user has no chance ... having a DATABASE field that accesses the same file as the mail merge's ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Plugging an alternate data source into MS-Access
    ... Linking to an existing database is quite easy. ... converting an existing Access database with non-standard datatypes, ... Is there a nice clean API between the forms and the data source? ...
    (comp.databases.ms-access)
  • Re: Dynamic DataSource paths?
    ... stores an "absolute" path to the data source, in this case the .odc file. ... Create your Word doc and save it in the same folder as the mdb file. ... Include the odc file with the doc and mdb files when you distribute the ... I want to distribute the Database with the Microsoft Word Mail Merge. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Mail Merge with Access not working
    ... Can you use /any/ of the queries in your database as a data source via DDE? ... Exchange when you attach the Access database to the mail merge ...
    (microsoft.public.word.mailmerge.fields)