linked csv file not all rows

  • Thread starter Thread starter karmela
  • Start date Start date
K

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
 
karmela said:
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
Click to expand...
 
karmela said:
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
Click to expand...
 
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
 
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
 
Back
Top