Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Inseting Data Into Access From SQL 7
Message
Information générale
Forum:
Visual Basic
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Divers
Thread ID:
00575821
Message ID:
00575893
Vues:
24
>I am having difficulty inerting data into an Access 2000 database from SQL 7.0using only a SQL statement. I have transferred data from Access to Access using the " INSERT INTO [Microsost Access Database].[Table name] " format. This, however causes an error when switching to SQL. I get an "Invalid Object Name" and then it states the full path name like c:\Jason.mdb.Payments where payments is the table. Any ideas on this one?

Hi Jason,

You may link source table (tblSource) to destination Access database. Then try make table SQL:
SELECT tblSource.* INTO tblDestination FROM tblSource;
HTH
Igor Gelin
Database Developer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform