You should be able to change a setting to make the first row denote the column names.
For the references to the default names, I am not sure about that (or exactlly what you're trying to do). Reuben Poon -----Original Message----- From: William H. Bowen [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 2:05 PM To: CF-Talk Subject: Re: Getting data from excel97 Importance: Low Well, that makes sense... the first row of the column is text (used for the column name) that may be what is happening. Can I make references to the default names of the excel columns when importing? (sheet1A,sheet1B,sheet1C,etc.) will ---- William H. Bowen Webmaster ALSTOM's Energy Management and Markets Business [EMAIL PROTECTED] http://www.esca.com/ ----- Original Message ----- From: "Reuben Poon" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 09, 2002 1:34 PM Subject: RE: Getting data from excel97 > Will, > > I've had lots of problems with Excel and exporting its data. Take a look at > the first row (or first few rows) of data in the Excel file. If it's a > blank value or a string, then Excel will convert the entire column to that > datatype. Sometimes you need to put data in the first few rows to get Excel > to not do this. > > Not sure if this made sense or not. Send me an email if you're still having > problems. > > Reuben Poon > [ [EMAIL PROTECTED] ] > > > > -----Original Message----- > From: William H. Bowen [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 09, 2002 1:31 PM > To: CF-Talk > Subject: OT: Getting data from excel97 > Importance: Low > > > My turn to post off-topic! Sorry! > > I have an excel file that is provided to me on a semi-regular basis. It > contains names of files, their owners and version numbers. > I import the data into a table in MSSQLServer 7 using DTS, no problem > there...BUT > > and there is always a but... > > There is a column full of numbers in the excell file that doesn't copy > completely in to the table _unless_ I go through the column manually and > place an apostrophe in front of every number. > > Oh...and non importing issue seems to happen randomly, sometimes one row, > sometimes 50. > > My questions then, are these: > 1. Is there a way that I can append the apostrophe to each row in that > particular column in the excel file before/during import? > 2. Is there something I can do to avoid this problem altogether and import > the data properly the first time? (i.e., am I missing something?) > > I think that should cover it for now. > > TIA > > will > ---- > > William H. Bowen > Webmaster > ALSTOM's Energy Management and Markets Business > > [EMAIL PROTECTED] > http://www.esca.com/ > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
