Prev: Recover records from ldf file.
Next: SQL Server 2008 on Windows 7 - Error 15401 Can't create login
From: Marcello on 20 Jan 2010 08:46
Hello everyone. I have an instance of SQL Server 2008 Express on my PC, I have
need to export tables from Access 2007 to SQL.
I did successfully migrate (table access with unique ID field
primary key) with SQL Server Migration Assistant for Access 2008, I
rechecking the tables in SQL and it's all ok.
Linking tables in Access.
I have saved import (from text files) that work without
problems with Access tables, when I go to do one of these
imports, at some point the message "Unable to register
changes. The entered value violates the settings for the
table or the list ...."
I have the same problem if I import from VBA code, and if
directly take the Access table with data (and are more of 1.500.00
record) and exports it via ODBC SQL executes correctly, that is
export of a table with data but does not import the data.
Can someone give me a straight because they are blocked?
Thanks to all, Hello
Marcello

From: Mary Chipman [MSFT] on 23 Jan 2010 11:52
I'm not exactly sure what's not working for you, but once you've
created the tables in SQL Server, you can link to them from your
Access database. In the Access database, you can create either an
Append or an Update query that uses the local Access/Jet tables as the
source and the SQL Server tables as the destination. If the table
schemas of the SQL Server and the Access/Jet tables are the same
(i.e., same PK), then this should work with no problems. You can then
execute the saved queries from your VBA code.

--Mary

On Wed, 20 Jan 2010 05:46:01 -0800, Marcello
<Marcello(a)discussions.microsoft.com> wrote:

>Hello everyone. I have an instance of SQL Server 2008 Express on my PC, I have
>need to export tables from Access 2007 to SQL.
>I did successfully migrate (table access with unique ID field
>primary key) with SQL Server Migration Assistant for Access 2008, I
>rechecking the tables in SQL and it's all ok.
>Linking tables in Access.
>I have saved import (from text files) that work without
>problems with Access tables, when I go to do one of these
>imports, at some point the message "Unable to register
>changes. The entered value violates the settings for the
>table or the list ...."
>I have the same problem if I import from VBA code, and if
>directly take the Access table with data (and are more of 1.500.00
>record) and exports it via ODBC SQL executes correctly, that is
>export of a table with data but does not import the data.
>Can someone give me a straight because they are blocked?
>Thanks to all, Hello
>Marcello
 | 
Pages: 1
Prev: Recover records from ldf file.
Next: SQL Server 2008 on Windows 7 - Error 15401 Can't create login