---
title: "INSERT - SQL Command | Microsoft Docs"
ms.custom: ""
ms.date: "01/19/2017"
ms.prod: sql
ms.prod_service: connectivity
ms.reviewer: ""
ms.technology: connectivity
ms.topic: conceptual
helpviewer_keywords: 
  - "INSERT [ODBC]"
ms.assetid: 9b648198-349f-46f6-b869-13d129945971
author: David-Engel
ms.author: v-daenge
---
# INSERT - SQL Command
Appends a record to the end of a table that contains the specified field values.  
  
 The Visual FoxPro ODBC Driver supports the native Visual FoxPro language syntax for this command. For driver-specific information, see the Remarks.  
  
## Syntax  
  
```  
  
INSERT INTO dbf_name [(fname1 [, fname2, ...])]  
   VALUES (eExpression1 [, eExpression2, ...])  
```  
  
## Arguments  
 INSERT INTO *dbf_name*  
 Specifies the name of the table to which the new record is appended. *dbf_name* can include a path and can be a name expression.  
  
 If the table you specify isn't open, it is opened exclusively in a new work area and the new record is appended to the table. The new work area isn't selected; the current work area remains selected.  
  
 If the table you specify is open, INSERT appends the new record to the table. If the table is open in a work area other than the current work area, it isn't selected after the record is appended; the current work area remains selected.  
  
 [( *fname1*[, *fname2*[, ...]])]  
 Specifies in the new record the names of the fields into which the values are inserted.  
  
 VALUES ( *eExpression1*[, *eExpression2*[, ...]])  
 Specifies the field values inserted into the new record. If you omit the field names, you must specify the field values in the order defined by the table structure.  
  
## Remarks  
 The new record contains the data listed in the VALUES clause.  
  
## Driver Remarks  
 When your application sends the ODBC SQL statement INSERT to the data source, the Visual FoxPro ODBC Driver converts the command into the Visual FoxProINSERT command without translation.  
  
## See Also  
 [CREATE TABLE - SQL Command](../../odbc/microsoft/create-table-sql-command.md)   
 [SELECT - SQL Command](../../odbc/microsoft/select-sql-command.md)