Does anybody know of a perl or something similiar that can take a csv
database and create a report. Assumptions the csv file is presorted
and is delimited with | pipes. Only one field will need to match.
R&D
Milpitas
393 Licoln Drive 33,000 sq.ft. 1.20
400 Maple Lane 12,000 sq.ft. 1.25
San Jose
31 First Street 40,000 sq.ft. 1.50
9 Third Street 30,000 sq.ft. 1.40
I've looked at ezscripting.com but they can't group by city.
Re: transfer data into an external database ... >With regards to your SQL code I have no idea about SQL. ... If there is a schema.ini in the same folder as the CSV file,... >> Create a Schema.ini file based on an existing table in your database:...John Nurick... (microsoft.public.access.externaldata)
Re: Pre-set Query Conditions that cannot be changed ... to a CSV file and then convert that CSV file in Word to a table, ... that 'Query Options have been set', but trying to change them reveals ... at a time into a blank database....methods required re-defintion of fields and reports. ... (microsoft.public.word.mailmerge.fields)
Re: PHP/MySQL project ... > Looking to build a dynamic site using PHP/MySQL. ... > import changes to the database easily.... Import the csv file into the MySql db, and then use phpmyadmin in the future ... The version of PHP will be important if you are considering finding / buying ... (alt.php)
Re: Pre-set Query Conditions that cannot be changed ... they have found out how to unlock the hidden Query Options.... the Works database is incompatible with Word and that some interoperability ... to a CSV file and then convert that CSV file in Word to a table, ...Word MVP web site http://word.mvps.org ... (microsoft.public.word.mailmerge.fields)
