how to transfer a database from ms access to ms sql 2005 through a button clik event in c#
gane_g86 0 Newbie Poster
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.