Recent content by mickeyj2

Thanks for your help.

Hi, Ok, here’s my situation. I have a CSV flat file. When you look at it in a text editor, the format is like: "Contact Name","Customer","Adr1","Adr2","Adr3","City","State","Zip","Ctry","Phone","Slsm","Email" In other words, quotes surround all of my data. In SSIS, I have built a package...

Hello, I'm back. After many frustrating tries, I think the best thing to do is to use SSIS to create a package, let SSIS clean it, and write the files into the table using a BULK INSERT. I also used a format file to accomplish this. It finally worked on a Friday evening right before I was...

Hi gmmastros, Thanks for all of your advice. I did try the followindg: SELECT * INTO XLImport5 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\test\xltest.xls', 'SELECT * FROM [Customers$]') And after enabling Ad Hoc Distributed Queries, I received this message: Msg...

Hmmm.... I guess this is a little over my head. I'm not understanding what I'm looking for. I'm see many "0d" and "0a" fields, but they're not at the end of my line? Why is this so convuluated? Someone ran a CSV file for me, and I haven't modified it at all, but just want to import. And I...

Hi, Ok. I should have clarified. I've tried several BULK INSERT statements. At first I had a comma-delimited file and then out of frustration, I tried making a tabbed file. That's where the \t came from. Also initially, my rowterminator was '\n\. So right now, I'm using the following...

Hi, Thank you for your comments. A couple of things. I did try importing the data using the import wizard, but it complained about my 11th column (that's the last column that I'm having trouble wtih). I'm copying a sample of my data, and this is dummy data not identifying real people...

Oh, by the way, I've seen several posts about quotes around the data. My files don't have any quotes around any of the data. Thanks.

Hi All, Can someone clue me in on BULK INSERT? I've used it to create a table of one column, and everything worked fine, but now I have a TXT file of about 11 fields. I've tried importing the data by using this as a comma-delimited CSV file, and I've tried the import by using it as a...

Hi, Good luck on your book. I was once like you and initially turned to Word for many desktop publishing tasks. Mine was creating manuals, etc. I know someone had suggested FrameMaker, but if you're looking for an entire suite, FrameMaker has been replaced with Adobe's InDesign, which is...

It's ok. I got it to load. I used an absolute path, but actually, I shouldn't have to do that. Thanks anyway.

Hi, Ok. I'm very, very new to Flash, though I've been developing for years. But I need to get a movie up and loaded on my website. I created a slideshow in Powerpoint, and then converted it to a .SWF file, which I loaded onto my site. Now in my Coldfusion file, I say the following: <EMBED...

Hi, I'm creating a search application. I have a file my srchform.cfm and it works fine. It returns results in the template srchresults.cfm. Here's some of the contents of my srchresults.cfm file: <CFSEARCH NAME="search_card" COLLECTION="card"...

Hi donb01, Thanks for the information. I really appreciate it. I'll try looking at this mail in Outlook as plain text and re-address defaulting my mails to plain text for users who can't read HTML. Thanks again for your help. mickeyj2

Hi, I'm in the process of creating some automated emails. I want to do it in HTML. In my company, the majority of my colleagues can accept an HTML format, but there's a handful that accept Plain Text only. I want to see how my HTML email will look in Plain Text. I tried using telnet to view...