Hi all
Im looking to populate my db from an excel spreadsheet. I think I have an
idea of how to do it. But Im sure there are some dos and donts that I not
aware of. So any comments are appreciated and thank you for taking the time
to look it over.
Im figuring my spread sheet would be set up just like the table rows.
Export in a delimited text file. Is tab delimited good?
Read with CFFILE, now I have my list of data in a varible. When using the
list functions to get data from the list, will I use the Chr() function to
specify the tab as the delimiter? (what is the ASCII value for a tab?)
Im figuring tab is a good delimiter because the some of the data in the list
are strings so I want to allow commas and quotes and things.
Thanks again,
Jeff
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
