![]() | |
#71
| |||
| |||
|
|
Right - but with ALines you are stuck to only being able to process this with a memofield and it won't work on large CSV files. Also, it won't work if there are CRLF between quotes per my earlier reply. It can work but I personally would probably go with StrTran if commas and CRLF are not an issue and size of the file is less than 16 megs. Otherwise I think he is stuck with either Append From CSV into a cursor or writing his own function depending on the parameters of the CSV file. |
#72
| |||
| |||
|
|
Right - but with ALines you are stuck to only being able to process this with a memofield and it won't work on large CSV files. Also, it won't work if there are CRLF between quotes per my earlier reply. It can work but I personally would probably go with StrTran if commas and CRLF are not an issue and size of the file is less than 16 megs. Otherwise I think he is stuck with either Append From CSV into a cursor or writing his own function depending on the parameters of the CSV file. |
#73
| |||
| |||
|
|
Right - but with ALines you are stuck to only being able to process this with a memofield and it won't work on large CSV files. Also, it won't work if there are CRLF between quotes per my earlier reply. It can work but I personally would probably go with StrTran if commas and CRLF are not an issue and size of the file is less than 16 megs. Otherwise I think he is stuck with either Append From CSV into a cursor or writing his own function depending on the parameters of the CSV file. |
![]() |
| Thread Tools | |
| Display Modes | |
| |