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 |
|
SergioM
Posting Yak Master
170 Posts |
 Posted - 2012-05-21 : 12:06:24
|
I'm using the import export tool to import a tilde-delimited .AP file. This particular document has 60 columns. But for whatever reason, I can only map 9 columns. The ninth column then has all of them lumped together in one column. It does read the tildes (~), but it only uses them to delimit for part of the file. Then it just begins to read them literally. Is there something I can do? P.S. The document is very large (over 125 MB!) so I can't really, manually alter the document (in excel or otherwise) prior to importing. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-21 : 16:51:02
|
| so far as delimiter is proper it should correctly interpret it. B/w have you given any text qualifier?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
SergioM
Posting Yak Master
170 Posts |
Posted - 2012-05-21 : 18:53:05
|
| I don't understand the first sentence. Can you rephrase it? Also, I have not given it a text qualifier. Should I? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-21 : 19:00:06
|
quote:
Originally posted by SergioM
I don't understand the first sentence. Can you rephrase it? Also, I have not given it a text qualifier. Should I?
My question was is it actually only ~ character which seperates values. Are the entire values enclosed in some qualifier like ""------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2012-05-22 : 06:27:57
|
Try to reset your columns again.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
SergioM
Posting Yak Master
170 Posts |
Posted - 2012-05-24 : 14:43:58
|
Resolved!So, for whatever reason, it only wanted to map 9 columns. But if I go to the advanced settings of the wizard & click "new"; it does properly include a new column. |
|
|
|
|
|
|
Import Tool does not properly delimit files