Hi



Does anyone of you know how to convert the CSV file into Excel format?



> -----Original Message-----

> From:	Imar Spaanjaars [SMTP:Imar@S...]

> Sent:	Monday, February 05, 2001 3:59 PM

> To:	ASP Database Setup

> Subject:	[asp_database_setup] Re: Excel Spreadsheet - Connection

> 

> Hi Steve,

> 

> For you Excel dataconnection, look here:

> http://members.tripod.com/~housten/exceldata.html

> 

> It might be outdated, but it works.

> 

> Another option is the following:

> http://support.microsoft.com/support/kb/articles/Q278/9/73.asp

> 

> 

> But even if you don't have a database program, you might be able to create

> 

> your own.

> By using ADOX you can create your own Access .MDB database file. You won't

> 

> get the fancy front end for designing the database etc, but it will let

> you 

> create a database, tables, columns etc etc. After that the database can 

> then be used as an ADO source.

> 

> Let me know if you need some pointers on how to do this.

> 

> HtH

> 

> Imar

> 

> 

> 

> At 03:02 AM 2/5/2001 +0000, you wrote:

> >I posted a message earlier regarding establishing a connection to a

> >Microsoft Works Database.  No takers so far.  How about an Excel

> >spreadsheet?  Can anyone provide a connection string for an Excel

> >spreadsheet?

> >

> >The problem is I don't have a database program, but I would like to

> >continue in "Beginning Active Server Pages 3.0."  But after Chapter 12,

> >without a data store, there's not much to do.  I realize this can only be

> >temporary, but if anyone can get me started with a connection string to

> >Excel, text file, or Microsoft Works database (or any other easily found

> >and connectible date store) it would be appreciated.

> >

> >(I asked Wrox about this, since the book said you can connect to a

> variety

> >of data stores, and I thought this might be a question supported by the

> >publisher.  But they referred me here - to p2p.)

> >

> >Steve