Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ruan4u
Posting Yak Master
132 Posts |
 Posted - 2005-06-30 : 09:02:36
|
| I have a CSV with a text qualifier.the sample data is"ABC","123"Using BI, how do i just get the data and not the double quotes.I have around 500K records and I cant DTS. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-06-30 : 09:20:53
|
| One possible way is let them insert as they are and remove them with replace functionMadhivananFailing to plan is Planning to fail |
 |
|
|
ruan4u
Posting Yak Master
132 Posts |
Posted - 2005-06-30 : 09:44:03
|
| well,actuallu its a dbf file.I dont know if BI can take DBF file.So from foxpro i did an export and it puts the text qualifier.Now is there a way in foxpro to ask it to export without a text qualifier. |
|
|
|
|
|
|
Bulk Insert with text qualifier