Hi, there are a lots of ways of doing this. you can take all the file an put
them on a data set and then send them to the SQLDB. But whend you have a lot
of data this proces is very slow. A quick ways of doing this is to create in
the sql server a LINKED SERVERS so you can use the two DB as one, in this
case you can copy data from one Db to other like you copy data from one
table to another.
I am using Visual Studio 2005 and Visual Studio SQL Express - I have two
tables from different data sources. One is an Access database that
contains
a product file, the other is an SQL database which is similar to the
Access
database but has no data.
I want to copy the data from the Access database accross to the SQL.
I have tried running a stored procedure but can get it working!
Any suggestions?
Re: TQL Debugger im SQL Server 2005 ... >>> Ich habe den SQL Server 2005 Developer Edition mit SQL Server ... >>> Database Services, Analysis Services, Integration Services und ... Ich habe ebenfalls Visual Studio 2005 ... (microsoft.public.de.sqlserver)
Linking an Access 2003 front-end to a SQL Server database using OD ... I have created an Access database which has several linked tables which are ... CRM) and they show when I use SQL Server Enterprise Manager,... I am using the SQL Server ODBC driver v 2000.85.1117.00. ... not updating data, I do not believe that the platform layer is contributing ... (microsoft.public.access.externaldata)
xp sp2 visual studio 2005 sql express 2005 bookcatalagapp ... I just installed Visual Studio 2005 90 day trial which comes with the ...sql server express database ... It uses the pubs db on sql express ... try invoke it which connects to the database but in my case no matter ... (microsoft.public.dotnet.framework.aspnet)
Re: upsizing access 2002 database to SQL Server 2000 - fatal error ... I have read on a few sites that sql server doesnt like empty bit (i.e. ... I have tried importing everything bar the data into a new access database,... > Personally I don't use SQL views as I always opt for stored procedures... (microsoft.public.access.conversion)
Datatype BIT problem with Access front-end AND SQL back-end ... This is the first time i post something on this forum, ...SQL database.... We were working with an Access database combined with Access forms. ... the conversion from a yes/no table in access to a BIT table in sql server.... (microsoft.public.access.formscoding)
