By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,045 Members | 1,305 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,045 IT Pros & Developers. It's quick & easy.

insert comand can modify structure of table?

juve11
P: 20
hello,
i have an app that imports csv files into mysql tables (not my app,so i dont have source code).a week ago that program worked.now,the soft doesnt works any more :The field is too small to accept the amount of data you attempted to load. Try inserting or pasting less data error 3163.

i looked in my csv and the table and both are ok for the field sizes,

can it be another reason for this?

a far much better programmer than me told me a while ago in a similar case that if one of the csv is different as structure than the database table and you try to import it,can broken the table (something like that...make it unusuable).

now i am trying to get the old structure of csv that worked and insert only one row of new data that hasnt yet been imported.if it doesnt work it means that the table is broken...
Jan 21 '08 #1
Share this Question
Share on Google+
7 Replies


debasisdas
Expert 5K+
P: 8,127
I never came across such a case where insert comand alters the structure of table
Jan 21 '08 #2

Expert 5K+
P: 8,434
I'd recommend you ask in the Access forum about this. (I can move the discussion over there if you like).

But I think it's much more likely there's simply something wrong with the CSV file that prevents it being imported. My first guess would be a misplaced or missing comma.
Jan 21 '08 #3

juve11
P: 20
This is what I'm also thinking. I took the structure of old csv file that worked and put in it just one row from the bad-csv and it worked.

I modified in the csv: there was a column with wrong data: instead of numbers up to 900 there were 1000 and bigger (but that field is varchar(64),so I correct those in Access and then export to csv, but it put data this way

"mike";;"washington"

and I changed ;; with ;""; :

"mike";"";"washington"

Now I'm waiting another answer as I sent another file to be imported.

I'll let you know.
Jan 21 '08 #4

juve11
P: 20
ok,now im getting error:

"Run-time error 5 ":
invalid procedure call or argument....
Jan 21 '08 #5

Expert 5K+
P: 8,434
"mike";;"washington"
That data is not in CSV format. CSV is Comma Separated Values. That data appears to be delimited with semicolons.
Jan 21 '08 #6

Expert 5K+
P: 8,434
ok,now im getting error:

"Run-time error 5 ":
invalid procedure call or argument....
This error sounds to me as though it's unrelated to the earlier problem. Can we get more details about it?

Also, I think your change to include quotes around the empty field probably won't have any noticeable impact. It depends, though - I seem to recall there are import options relating to empty fields.
Jan 21 '08 #7

juve11
P: 20
i made the changes:
replace ;; with ;"";
also i had some filed that started with " 999999999", so i deleted the white spaces.

i am sending to import small pieces of the large csv files,until now, 2 of thoose small pieces WORKED and were imported.i am waiting for another response and hope it is ok. and if is not, i will post here when i find the row with problem.

thank you all.
Jan 22 '08 #8

Post your reply

Sign in to post your reply or Sign up for a free account.