| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get rid of quotation marks when importing
I use excel to set up products that I then import to my web site. Many times
the item descriptions contain ". When I import these extra " are added and show up on my website. Anyone know how to keep this from happening? I'm using tab delimited. -- Thanks :) Lori |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Get rid of quotation marks when importing
In your query include this parameter
..TextFileTextQualifier = xlTextQualifierDoubleQuote "Lori" wrote: I use excel to set up products that I then import to my web site. Many times the item descriptions contain ". When I import these extra " are added and show up on my website. Anyone know how to keep this from happening? I'm using tab delimited. -- Thanks :) Lori |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Get rid of quotation marks when importing
Sorry...newbie.
In my query? Where do I find that? -- Thanks :) Lori "Joel" wrote: In your query include this parameter .TextFileTextQualifier = xlTextQualifierDoubleQuote "Lori" wrote: I use excel to set up products that I then import to my web site. Many times the item descriptions contain ". When I import these extra " are added and show up on my website. Anyone know how to keep this from happening? I'm using tab delimited. -- Thanks :) Lori |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Get rid of quotation marks when importing
Sorry, I thought you werer creating a macro. The best way of importing data
is through the Import wizard. When Import Wizard comes up select Delimited, hit Next Button, and then select TAB. On this menu there is a Delimiter box. make sure it is Double Quote (not none or signle quote). This should solve your problem. If no Wizard comes up then you have to import the data using the following menu Data - Import External Data - Import Data. Slect the file type on the bottom of the menu and then follow instructions above. "Lori" wrote: Sorry...newbie. In my query? Where do I find that? -- Thanks :) Lori "Joel" wrote: In your query include this parameter .TextFileTextQualifier = xlTextQualifierDoubleQuote "Lori" wrote: I use excel to set up products that I then import to my web site. Many times the item descriptions contain ". When I import these extra " are added and show up on my website. Anyone know how to keep this from happening? I'm using tab delimited. -- Thanks :) Lori |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Get rid of quotation marks when importing
Dang, other than selecting tab delimited these are my only other choices.
attribute templates on the import products link on the site... Attribute Templates: Use Copy I can select use or copy. Those are my only 2 choices. Would it make more sense to use something like CuteFTP? -- Thanks :) Lori "Joel" wrote: Sorry, I thought you werer creating a macro. The best way of importing data is through the Import wizard. When Import Wizard comes up select Delimited, hit Next Button, and then select TAB. On this menu there is a Delimiter box. make sure it is Double Quote (not none or signle quote). This should solve your problem. If no Wizard comes up then you have to import the data using the following menu Data - Import External Data - Import Data. Slect the file type on the bottom of the menu and then follow instructions above. "Lori" wrote: Sorry...newbie. In my query? Where do I find that? -- Thanks :) Lori "Joel" wrote: In your query include this parameter .TextFileTextQualifier = xlTextQualifierDoubleQuote "Lori" wrote: I use excel to set up products that I then import to my web site. Many times the item descriptions contain ". When I import these extra " are added and show up on my website. Anyone know how to keep this from happening? I'm using tab delimited. -- Thanks :) Lori |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Get rid of quotation marks when importing
Can you copy to a file? Then open the file from excel with the options I
specified. If you can't copy to a file then copy to the excel speadsheet in column A. then use Text- to - columns (under worksheet data menu). the text to columns have the same options and the Import External Data. "Lori" wrote: Dang, other than selecting tab delimited these are my only other choices. attribute templates on the import products link on the site... Attribute Templates: Use Copy I can select use or copy. Those are my only 2 choices. Would it make more sense to use something like CuteFTP? -- Thanks :) Lori "Joel" wrote: Sorry, I thought you werer creating a macro. The best way of importing data is through the Import wizard. When Import Wizard comes up select Delimited, hit Next Button, and then select TAB. On this menu there is a Delimiter box. make sure it is Double Quote (not none or signle quote). This should solve your problem. If no Wizard comes up then you have to import the data using the following menu Data - Import External Data - Import Data. Slect the file type on the bottom of the menu and then follow instructions above. "Lori" wrote: Sorry...newbie. In my query? Where do I find that? -- Thanks :) Lori "Joel" wrote: In your query include this parameter .TextFileTextQualifier = xlTextQualifierDoubleQuote "Lori" wrote: I use excel to set up products that I then import to my web site. Many times the item descriptions contain ". When I import these extra " are added and show up on my website. Anyone know how to keep this from happening? I'm using tab delimited. -- Thanks :) Lori |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Quotation Marks | Excel Discussion (Misc queries) | |||
| Quotation Marks? | Excel Worksheet Functions | |||
| without quotation marks? | Excel Discussion (Misc queries) | |||
| Quotation Marks - When and What?? | Excel Discussion (Misc queries) | |||
| quotation marks | Excel Worksheet Functions | |||
Hybrid Mode
