linked csv file not all rows

[karmela]

Hello,

I'm optimazing my access file (Access 2007) and I would like to link csv
files (exported from our ERP system).
Some of them is linked OK and the number of rows in Access matches that
number in CSV. In one case I have 1642 rows, but in Access I see just 896
rows. The data seem the same format in each row. I have relinked it again,
but unsuccesfully.

Is there any solution for ensuring the complete import, also when it appears
by the other files? I do not want to copy/paste the data manually :-(

Thanks a lot

karmela

 

[georges lebas]

Hello,

I'm optimazing my access file (Access 2007) and I would like to link csv
files (exported from our ERP system).
Some of them is linked OK and the number of rows in Access matches that
number in CSV. In one case I have 1642 rows, but in Access I see just 896
rows. The data seem the same format in each row. I have relinked it again,
but unsuccesfully.

Is there any solution for ensuring the complete import, also when it
appears
by the other files? I do not want to copy/paste the data manually :-(

Thanks a lot

karmela

 

[karmela]

Hello,

thanks for the answer, but I cannot find it...
karmela

 

[karmela]

Hello

does anyone know, how can be solved this problem? I have try also importing
the file, but the result is same :-(

Thank you

karmela

 

[Gina Whipp]

karmela,

Does your linked table have any relationships to other tables? Do you see
any Paster Errors tables? Can you identify which rows? Perhaps the have
commas or other characters that are preventing the row from importing?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm