จดกันลืม Connecting CSV (Text Delimiter) Database On The Fly
Text Delimited Database files are files that have each column separated by a specified delimiter (a comma, semicolon, etc.), and each separate row specified by a new line character. In Excel or Access you can save your tables as comma delimited files. A comma delimited file is an example of a text delimited file. This article will show you how to connect to CSV (Text Delimited) Database files on the fly. Connecting CSV (Text Delimiter) Database On The Fly: What do you have to do to make this code work: 1. Create virtual directory having script permission 2. Create a "Microsoft Text Driver" file DSN from your ODBC32 from Control Panel. Name it "CSV.DSN" (see appendix A) or Copy and paste the text from appendix A 3. Save sample data below to "data.txt" (see appendix B) 4. Save this article as "AnyName.asp" 5. Copy all the three files ("csv.dsn", "data.txt", and "AnyName.asp") on your virtual directory havi...