updating data in mysql

I've noticed in my project when I move records from one table to another escpecially a large amount of data I lose some data in the fields and they are not blank.When I move a smaller portion of data everything gets moved over good.I'm updating like this

with rs1.addnew
!column1 = rs2.Column2
!column2 = rs2.column2
.update


is there something that I am missing?
LVL 8
thenoneAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

leclairmCommented:
Are you sure the primary keys are matching between the tables when you are doing the update??
thenoneAuthor Commented:
So if I do not have primary keys setup this would cause missing data to being updated in the columns?
leclairmCommented:
Actually, forget what I said.  Your adding records, not updating them.  Sorry, my mistake.
CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

thenoneAuthor Commented:
So what could it be?

This only happens when Im moving large amount of data?
thenoneAuthor Commented:
My tables are isam tables and not innodb I wonder if this is the case?
leclairmCommented:
You could always try using an insert statement directly against your connection that rs1 is using.

Ex:

conn1.execute "insert into table1 (column1,column2) values (" & rs2!column1 & "," & rs2!column2 & ")"
thenoneAuthor Commented:
actually the values being inserted are strings.I just find it weird that it only happens when I'm inserting alot of data.
PockyMasterCommented:

Execute this on your connection object and you can import ALL your rows at once.
iterating and updating causes a lot of performance degradation.
That is not what you want.

INSERT INTO myNewTable (field1,field2)
SELECT OT.field1, OT.field2 FROM myOldTable OT
pradapkumarCommented:
If u use Large sized Strings Other than Varchar(255) like TinyText or MediumText data types lost its data while u referencing their corresponding field cordinates like !Filed1
So, First move that data to a string type variable first and then use it for ex.
strTemp = !Field1
so, the data first moved to temporary local variable and then it will be referenced as many times as u wish.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.