how to transfer a database from ms access to ms sql 2005 through a button clik event in c#
gane_g86
0
Newbie Poster
Recommended Answers
Jump to PostDoes the DB exist in ms sql already, with tables etc? or, are you trying to make it on the fly?
All 2 Replies
LizR
171
Posting Virtuoso
Does the DB exist in ms sql already, with tables etc? or, are you trying to make it on the fly?
Jx_Man
987
Nearly a Senior Poster
Featured Poster
Yes, lizR right...
Make sure the table name is same (field, length and datatype too).
Read data from Access (using loop) then write certain data into MSSQL (this the logic, i never tried this).
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.