dothvader
Mon Feb 26 08:50:15 CST 2007
On Feb 24, 12:22 pm, "Thomas A. Rowe" <tar...@mvps.org> 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...@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 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.