I did the following to resolve the problem.
1. Your create command didnt work for me and I changed the add(128) on line
6 to addrs varchar(128). I suppose this was a typo since you already had a
working table.
2. Your main problem comes from the format of your input. Use /N for
ommited column
On Thursday, Oct 10, 2002, at 02:26 America/Phoenix, Nasir Aziz Gill
wrote:
> Hi fellows,
>
> I got one text file of 9816 records (9816 lines) seprated by commas and
> enclosed by the inverted quotes and seprated by the end of lines. But
> when I
> import the file, it only gets half of recor
Hi
Two thoughts
try \r\n instead of \n
or
if you are getting warnings it may be that there is a problem with the
data - illegal characters or something?
if neither works email me offlist and I will take a look, if that helps.
HTH
Peter
---
Excel
