linked csv file not all rows

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
 
G

georges lebas

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
 
K

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top