Hi Faqir,
This article walk you step by step...this article assume that you have full [DBA]access to the SQL Server:
If you don't have full access to the SQL Server [you can only connect to the SQL Server e.g. link table] then you can do the following:
- Create an ODBC to connect to SQL Server
- Create an Append Query [to append to the SQL Server's table]
When transfering data you MUST consider the data type equivalents for both database; check this article for that:
Hope that helps!
Manuel
faqir_suit <[EMAIL PROTECTED]> wrote:
Hi, plz any body tell how to transfer the data from access tables in
to sql server tables(i just want transfer of data as both database
structure is diffrent)
Yahoo! DSL Something to write home about. Just $16.99/mo. or less
Please zip all files prior to uploading to Files section.
SPONSORED LINKS
| Microsoft access developer | Microsoft access help | Microsoft access database |
| Microsoft access training | Microsoft access training course | Microsoft access programming |
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
