copy data from table1 to table2

[mathanraj76]

Hi..

I want copy data from table1 data to table2 with using command button

In table1
Fields name Datatype
customername text
Add1 text
Add2 text
qty1 text
qty2 text


In table2


from table1 copy to table2
fields Name datatype
customer name text
Add1 text
Add2 text
qty1 number
qty2 number

In my table1 datatype is everthing in text but in my table2 some datatype is in text and number
I really need help on this


Thanks
Mathanraj

[rzw0wr]

Are you wanting to just change the data type to number?

Dale

[Missinglinq]

As Dale has suggested, we really need to know your ultimate purpose, here. Copying the entire content from one Table to another violates the rules of Relational Databases. If you object is, indeed, simply to change the Datatypes of qty1 and qty2 from Text to Numbers you can do that in Table Design View; you'll receive a warning message that you may lose some data, but assuming that the data looks like 'numbers,' i.e. is all digits, that won't occur.

Linq ;0)>

[rzw0wr]

My thoughts exactly Linq.

Dale

[rzw0wr]

BTW, In Bank table change the PK from text to AutoNumber.
I just added another row (tblBank_ID) for this and made that row PK.

Dale

[mathanraj76]

In table1 i have data's and all in the dataype is in text
and now i want to copy the entire data's
from table1 to table2 but the qty1 change from text to number in datatype in table2.
When I press command button it must copy the entire data's from table1 to table2

I have attached sample database

Thanks
Mathanraj

[June7]

Why do you want to copy data? If your true goal is just to change all the 'Q' fields to number type, simply open the table in design view and change the data type.

[mathanraj76]

The user will run this program.
So i don't want the user to modify the table ..
That's why i going put the command button to copy the data from table 1 to table2 . with changing the data type for only in 'Q' fields.
If the 'Q' is in text data type then if use search command for the fields 'Q' can't be process..
Only if 'Q' is in number data type it can be search..

Thanks
Mathanraj

[Missinglinq]

...Only if 'Q' is in number data type it can be search...

Where did you find that bit of misinformation? You can search on Fields of any Datatype, you simply have to use the proper syntax, which differs according to Datatype!

What code are you currently using to perform your search?

Linq ;0)>

[mathanraj76]

I have attached the source code for search command..which i use ..


Thanks
Mathanraj

[June7]

I thought this search issue was already addressed and solved in other thread https://www.accessforums.net/program...tml#post174708

Ling, OP has numeric data stored in text fields and filter criteria will not work correctly until the fields are changed to number type.

[mathanraj76]

Hi..June7

But i have problem on my table to change the data type from text to number
But I know it can be used it sql as "ALTER TABLE WITH MY TABLE NAME(MY FIELDS NAME AND DATATYPE) it can be change but i want to know how to do in vba..
the rest of it was done and solved

Thanks

[June7]

Why do you need to use VBA and SQL to change datatype? Open the table in design view and change the data type. Done. Simple. No code.

Then the search code I provided in other thread should work just fine.

[mathanraj76]

OK..I follow your Instructions..
It should be more easy way to change the datatype..
Thanks
Mathanraj