Import or link to data in an Excel workbook

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007.

You can bring the data from an Excel workbook into Access databases in many ways. You can copy data from an open worksheet and paste it into an Access datasheet, import a worksheet into a new or existing table, or link to a worksheet from an Access database.

This topic explains in detail how to import or link to Excel data from Access desktop databases.

What do you want to do?

Understand importing data from Excel

Import data from Excel

Troubleshoot missing or incorrect values

Link to data in Excel

Troubleshoot #Num! and other incorrect values in a linked table

Understand importing data from Excel

If your goal is to store some or all of your data from one or more Excel worksheets in Access, you should import the contents of the worksheet into a new or existing Access database. When you import data, Access creates a copy of the data in a new or existing table without altering the source Excel worksheet.

Common scenarios for importing Excel data into Access

  • You are a long-time user of Excel but, going forward, you want to use Access to work with this data. You want to move the data in your Excel worksheets into one or more new Access databases.
  • Your department or workgroup uses Access, but you occasionally receive data in Excel format that must be merged with your Access databases. You want to import these Excel worksheets into your database as you receive them.
  • You use Access to manage your data, but the weekly reports you receive from the rest of your team are Excel workbooks. You would like to streamline the import process to ensure that data is imported every week at a specific time into your database.

If this is the first time you are importing data from Excel

  • There is no way to save an Excel workbook as an Access database. Excel does not provide functionality to create an Access database from Excel data.
  • When you open an Excel workbook in Access (in the File Open dialogue box, change the Files of Type list box to Microsoft Office Excel Files and select the file you want), Access creates a link to the workbook instead of importing its data. Linking to a workbook is fundamentally different from importing a worksheet into a database. For more information about linking, see the section Link to data in Excel, later in this article.

Import data from Excel

The steps in this section explain how to prepare for and run an import operation, and how to save the import settings as a specification for later reuse. As you proceed, remember that you can import data from only one worksheet at a time. You cannot import all the data from a whole workbook at the same time.

Prepare the worksheet

  1. Pinpoint the source file and choose the worksheet with your essential data to import to Access. If you want to import merely a section of a worksheet, you can set a named range that solely contains your preferred cells to import.


Define a named range (optional)   

a. Switch to Excel and access the worksheet containing your required data to import.

b. Pick the range of cells that include your desired data to import.

c. Right-click within the highlighted range and then select Name a Range or Define Name.

d. In the New Name dialogue box, assign a name for the range in the Name box and press OK. Take note that you can import only one worksheet in sequence during an import operation. To import data from several worksheets, repeat the import operation for every worksheet.

  1. Inspect the source data and perform steps as outlined in this table.
ElementDescription
Number of columnsThe number of source columns that you want to import only accepts up to 255, because Access does not support higher than 255 fields in a table.
Skipping columns and rowsIt is a good practice to add only the rows and columns that you want to import in the source worksheet or named range.

Rows  –  You cannot filter or skip rows during the import operation.

Columns  –  You cannot skip columns during the operation if you choose to add the data to an existing table.
Tabular formatEnsure that the cells are in tabular format. If the worksheet or named range includes merged cells, the contents of the cell are placed in the field that corresponds to the leftmost column, and the other fields are left blank.
Blank columns, rows, and cellsDelete all obsolete blank columns and blank rows in the worksheet or range. If the worksheet or range contains blank cells, try to add the missing data. If you are planning to append the records to an existing table, ensure that the corresponding field in the table accepts null (missing or unknown) values. A field will accept null values if its Required field property is set to No and its ValidationRule property setting doesn’t prevent null values.
Error valuesIf one or more cells in the worksheet or range contain error values, such as #NUM and #DIV, correct them before you start the import operation. If a source worksheet or range contains error values, Access places a null value in the corresponding fields in the table. For more information about ways to correct those errors, see the section Troubleshoot missing or incorrect values, later in this article.
Data typeTo avoid errors during importing, ensure that each source column contains the same type of data in every row. Access scans the first eight source rows to determine the data type of the fields in the table. We highly recommend that you ensure that the first eight source rows do not mix values of different data types in any of the columns. Otherwise, Access might not assign the correct data type to the column.Also, it is a good practice to format each source column in Excel and assign a specific data format to each column before you start the import operation. Formatting is highly recommended if a column includes values of different data types. For example, the FlightNo column in a worksheet might contain numeric and text values, such as 871, AA90, and 171. To avoid missing or incorrect values, do the following:

a. Right-click the column header and then click Format Cells.

b. On the Number tab, under Category, select a format. For the FlightNo column, you would probably choose Text.

c. Click OK.If the source columns are formatted, but still contain mixed values in the rows following the eighth row, the import operation might still skip values or convert values incorrectly. For troubleshooting information, see the section Troubleshoot missing or incorrect values.
First rowIf the first row in the worksheet or named range contains the names of the columns, you can specify that Access treat the data in the first row as field names during the import operation. If your source worksheet or range doesn’t include the names, it is a good idea to add them to the source before you start the import operation.

Note: If you plan to append the data to an existing table, ensure that the name of each column exactly matches the name of the corresponding field. If the name of a column is different from the name of the corresponding field in the table, the import operation will fail. To see the names of the fields, open the table in Design view in Access.

  1. Exit the source workbook, if it is open. Leaving the source file open may cause data conversion issues amid the import operation.

Prepare the destination database

  1. Launch the Access database in which the imported data will be stored. Check that the database is not read-only, and that you have editing permissions to set changes to the database. -or- If you don’t want to store the data in any of your current databases, produce a blank database. To do so: Select the File tab, press New, and then choose Blank Database.

  1. Before you start the import operation, clarify whether you want to store the data in a new or present table. Create a new table  –  If you decide to store the data in a new table, Access forms a table and appends the imported data to this table. If a table with the indicative name already exists, Access replaces the contents of the table with the imported data. Append to an existing table  –  If you opt for inserting the data to an existing table, the rows in the Excel worksheet are inserted to the particular table. Remember that nearly all errors during append operations happen since the source data is mismatched with the structure and field settings of the destination table. To avoid this, access the destination table in Design view and review the following:

  • First row  –  If the first row of the source worksheet or named range is missing any column headings, check that the position and data type of each column in the source worksheet reflects those of the corresponding field in the table. If the first row has column headings, the order of columns and fields are fine if they are different, but the name and data type of each column must precisely match those of its related field.
  • Missing or extra fields  –  If one or additional fields in the source worksheet are absent from the destination table, append them before you commence the import operation. However, if the table includes non-existent fields in the source, you can preserve those fields from the table if they accept null values.

Tip: A field will accept null values if its Required property is defined as No and its ValidationRule property setting isn’t set to preclude null values.

  • Primary key  –  If the table includes a primary key field, the source worksheet or range must embody a column that has values that are suited to the primary key field, and the imported key values should be unique. If an imported record includes a primary key value that is already found in the destination table, the import operation presents an error message.
  • Indexed fields  –  If the Indexed property of a field in the table is programmed to Yes (No Duplicates), the related column in the source worksheet or range must encompass unique values. Follow the next steps to perform the import operation.

Start the import operation

  1. The location of the import/link wizard varies to some degree based upon your version of Access. Select the steps that match your Access version:
  • If you’re using the latest version of the Microsoft 365 subscription version of Access or Access 2019, on the External Data tab, in the Import & Link group, pick New Data Source > From File > Excel.
  • If you’re using Access 2016, Access 2013, or Access 2010, on the External Data tab, in the Import & Link group, press Excel.

Note: The External Data tab is unavailable unless a database is open.

  1. In the Get External Data – Excel Spreadsheet dialogue box, in the File name box, elaborate the name of the Excel file that includes the data that you want to import. -or- Press Browse and use the File Open dialogue box to find your desired file to import.
  1. Determine how you want to store the imported data. To store the data in a new table, click Import the source data into a new table in the current database. You will be requested to name this table later. To add the data to an existing table, pick Append a copy of the records to the table and confirm a table from the drop-down list. This option is not available if the database excludes tables. To link to the data source by making a linked table, see the section Link to data in Excel, later in this article.
  1. Press OK. The Import Spreadsheet Wizard begins, and moves you through the import process. Read on for the next set of steps.

Use the Import Spreadsheet wizard

  1. On the first page of the wizard, pick the worksheet that contains the data that you want to import, and then press Next.
  1. On the second page of the wizard, select either Show Worksheets or Show Named Ranges, click either the worksheet or the named range that you want to import, and then pick Next.
  1. If the first row of the source worksheet or range contains the field names, click First Row Contains Column Headings and choose Next. If you are importing the data into a new table, Access employs these column headings to name the fields in the table. You can update these names either during or after the import operation. If you are adding the data to an existing table, check that the column headings in the source worksheet entirely correspond to the names of the fields in the destination table. If you are importing data to an existing table, skip directly to step 6. If you are inserting the data to a new table, follow the remaining steps.
  1. The wizard urges you to inspect the field properties. Select a column in the lower half of the page to indicate the associated field’s properties. Optionally, do any of the following:
  • Review and change, if preferable, the name and data type of the destination field. Access reviews the first eight rows in every column to imply the data type for the related field. If the column in the worksheet includes various types of values, like text and numbers, in the first eight rows of a column, the wizard recommends a data type that is functional with each value in the column — most frequently, the text data type. However, you can select an alternative data type, remember that values that are mismatched with the data type that you select will be either skipped or transformed wrongly during the import process. For more information about how to correct missing or incorrect values, see the section Troubleshoot missing or incorrect values, later in this article.
  • To design an index on the field, set Indexed to Yes.
  • To fully omit a source column, click the Do not import field (Skip) checkbox. Pick Next once you finish choosing options.

  1. In the next screen, set a primary key for the table. If you click Let Access add primary key, Access appends an AutoNumber field as the first field in the destination table, and promptly occupies it with unique ID values, beginning with 1. Press Next.
  1. In the final wizard screen, define a name for the destination table. In the Import to Table box, enter a name for the table. If the table already exists, Access launches a prompt that asks if you want to substitute the current contents of the table. Pick Yes to continue or No to set a different name for the destination table, and then select Finish to import the data. If Access managed to import some or all the data, the wizard presents a page that displays you the status of the import operation. Moreover, you can save the information of the operation for future use as a specification. In contrast, if the operation completely malfunctioned, Access shows the message An error occurred trying to import file.
  1. Select Yes to save the operational details for future use. Saving the details aids you to repeat the operation in future without having to complete the entire wizard constantly.

See Save the details of an import or export operation as a specification to learn how to save your save your specification details.

See Run a saved import or export specification to learn how to run your saved import or link specifications.

See Schedule an import or export specification to learn how to schedule import and link tasks to run at specific times.

Troubleshoot missing or incorrect values

If you get the message An error occurred trying to import file, the import operation was a complete disaster. Conversely, if the import operation presents a dialogue box that asks you to save the details of the operation, the operation succeeded in importing all or part of the data. The status message even states the name of the error log table that includes the description of any errors that surfaced during the import operation.

Important: Even if the status message alludes to a wholly successful operation, you should inspect the contents and structure of the table to guarantee that everything looks in working order before you start using the table.

  • Enter the destination table in Datasheet view to verify whether all data was applied to the table.
  • Access the table in Design view to check the data type and other property settings of the fields.

The following table summarises the steps that you can take to rectify missing or incorrect values.

Tip: While you are troubleshooting the results, if you find only a few missing values, you can append them to the table manually. On the other hand, if you find that whole columns or a vast number of values are either missing or were not improperly imported, you should fix the problem in the source file. Once you have rectified every known problem, repeat the import operation.

IssueResolution
Graphical elementsGraphical elements, such as logos, charts, and pictures cannot be imported. Manually add them to the database after completing the import operation.
Calculated valuesThe results of a calculated column or cells are imported, but not the underlying formula. During the import operation, you can specify a data type that is compatible with the formula results, such as Number.
TRUE or FALSE and -1 or 0 valuesIf the source worksheet or range includes a column that contains only TRUE or FALSE values, Access creates a Yes/No field for the column and inserts -1 or 0 values in the field. However, if the source worksheet or range includes a column that contains only -1 or 0 values, Access, by default, creates a numeric field for the column. You can change the data type of the field to Yes/No during the import operation to avoid this problem.
Multivalued fieldsWhen you import data to a new table or append data to an existing table, Access does not enable support for multiple values in a field, even if the source column contains a list of values separated by semicolon (;). The list of values is treated as a single value and is placed in a text field.
Truncated dataIf data appears truncated in a column in the Access table, try increasing the width of the column in Datasheet view. If that doesn’t resolve the issue, the data in a numeric column in Excel is too large for the field size of the destination field in Access. For example, the destination field might have the FieldSize property set to Byte in an Access database but the source data contains a value greater than 255. Correct the values in the source file and try importing again.
Display formatYou might have to set the Format property of certain fields in design view to ensure that the values are displayed correctly in Datasheet view. For example:A Yes/No field displays -1 and 0 in Datasheet view after the import operation is completed. To fix this, after the import operation is complete, set the field’s Format property to Yes/No to display check boxes instead.

Long and medium dates might appear as short dates in Access. To fix this, open the destination table in Design view in Access and set the date field’s Format property to Long Date or Medium Date.

Note: If the source worksheet contains rich text formatting such as bold, underline, or italics, the text is imported, but the formatting is lost.
Duplicate values (key violation error)Records that you are importing might contain duplicate values that cannot be stored in the primary key field of the destination table or in a field that has the Indexed property set to Yes (No Duplicates). Eliminate the duplicate values in the source file and try importing again.
Date values off by 4 yearsThe date fields that are imported from an Excel worksheet might be off by four years. Excel for Windows uses the 1900 Date System (in which serial numbers range from 1 to 65,380), which correspond to the dates January 1, 1900 through December 31, 2078. However, Excel for the Macintosh uses the 1904 Date System (in which serial numbers range from 0 to 63,918), which correspond to the dates January 1, 1904 through December 31, 2078.

Before you import the data, change the date system for the Excel workbook or, after appending the data, perform an update query that uses the expression [date field name] + 1462 to correct the dates.
Null valuesYou might see an error message at the end of the import operation about data that was deleted or lost during the operation, or when you open the table in Datasheet view, you might see that some field values are blank. If the source columns in Excel are not formatted, or the first eight source rows contain values of different data types, open the source worksheet and do the following:

Format the source columns.

Move the rows so that the first eight rows in each column do not contain values of different data types.

During the import operation, select the appropriate data type for each field. If the data type is incorrect, you might see null values or incorrect values in the entire column after the import operation has completed.

The preceding steps can help minimise the appearance of null values. The following list displays cases in which you will still see null values:


The values that are missing are of type…
Text

When importing to…
A new table

An existing table

And the destination field type is…
Date

Numeric or Date

To resolve…
Replace all text values with date values and then try importing again

Replace all text values with values that match the data type of the destination field and then try importing again.
Date values replaced by numeric valuesYou will see seemingly random five-digit numbers instead of the actual date values in the following situations:

The source column in the worksheet contains only numeric values in the first eight rows, but contains some date values in the subsequent rows. These date values will be converted incorrectly.

The source column contains date values in some of the first eight rows, and you attempted to import it into a numeric field. These date values will be converted incorrectly.

To avoid this, replace the date values with numeric values in the source column and try importing again.

Sometimes, if a column that contains mostly date values also contains several text values, all the date values might appear as seemingly random five-digit numbers. To avoid this, replace the text values with date values and then try importing again.
Numeric values replaced by date valuesYou will see seemingly random date values instead of the actual numeric values in the following situations:The source column contains only date values in the first eight rows, but contains some numeric values in the subsequent rows. These numeric values will be converted incorrectly.

The source column contains numeric values in some of the first eight rows, and you attempted to import it into a date field. These numeric values will be converted incorrectly.

To avoid this, replace the numeric values with date values in the source column and then try importing again.

Moreover, you may want to review the error log table (mentioned in the last page of the wizard) in Datasheet view. The table contains three fields — Error, Field, and Row. Each row includes information about a distinct error, and the contents of the Error field should inform you about how to troubleshoot the problem.

Error strings and troubleshooting hints

ErrorDescription
Field TruncationA value in the file is too large for the FieldSize property setting for this field.
Type Conversion FailureA value in the worksheet is the wrong data type for this field. The value might be missing or might appear incorrect in the destination field. See the previous table for more information how to troubleshoot this issue.
Key ViolationThis record’s primary key value is a duplicate — it already exists in the table.
Validation Rule FailureA value breaks the rule set by using the ValidationRule property for this field or for the table.
Null in Required FieldA null value isn’t allowed in this field because the Required property for the field is set to Yes.
Null value in AutoNumber fieldThe data that you are importing contains a Null value that you attempted to append to an AutoNumber field.
Unparsable RecordA text value contains the text delimiter character (usually double quotation marks). Whenever a value contains the delimiter character, the character must be repeated twice in the text file; for example:4 1/2″” diameter

Top of Page

Link to data in Excel

By linking an Access database to data in another programme, you can employ the querying and reporting tools that Access supplies without needing to retain a copy of the Excel data in your database.

After you link to an Excel worksheet or a named range, Access designs a new table that is linked to the source cells. Any updates that you make to the source cells in Excel emerge in the linked table. However, you cannot modify the contents of the matching table in Access. If you want to create, edit, or delete data, you have to apply the changes in the source file.

Common scenarios for linking to an Excel worksheet from within Access

Typically, you link to an Excel worksheet (as a replacement for importing) for the following reasons:

  • You want to proceed with maintaining your data in Excel worksheets, but be able to apply the powerful querying and reporting features of Access.
  • Your department or workgroup uses Access, but data from external sources that you work with is in Excel worksheets. You seek to avoid retaining copies of external data, but want regular access to it within Access.

If this is the first time you are linking to an Excel worksheet

  • You cannot create a link to an Access database from within Excel.
  • When you link to an Excel file, Access creates a new table, often referred to as a linked table. The table shows the data in the source worksheet or named range, but it doesn’t actually store the data in the database.
  • You cannot link Excel data to an existing table in the database. This means that you cannot append data to an existing table by performing a linking operation.
  • A database can contain multiple linked tables.
  • Any changes that you make to the data in Excel are automatically reflected in the linked table. However, the contents and structure of a linked table in Access are read-only.
  • When you open an Excel workbook in Access (in the File Open dialogue box, change the Files of Type list box to Microsoft Excel, and select the file you want), Access creates a blank database and automatically starts the Link Spreadsheet Wizard.

Prepare the Excel data

  1. Find the Excel file and the worksheet or range that has the data you want to link to. If you don’t want to link to the entire worksheet, another approach you can adopt is to define a named range that embodies only the cells you want to link to.

    Create a named range in Excel (optional – useful if you only want to link to some of the worksheet data)   

a. Switch to Excel and launch the worksheet in which you want to define a named range.

b. Click the range of cells that contain the data you want to link to.

c. Right-click within the highlighted range and select Name a Range or Define Name.

d. In the New Name dialogue box, confirm a name for the range in the Name box and then press OK. Note that you can link to simply one worksheet or range in turn during a link operation. To link to data in numerous places in a workbook, repeat the link operation for each worksheet or range.

ElementDescription
Tabular formatEnsure that the cells are in tabular format. If the range includes merged cells, the contents of the cell are placed in the field that corresponds to the leftmost column and the other fields are left blank.
Skipping columns and rowsYou cannot skip source columns and rows during the linking operation. However, you can hide fields and filter records by opening the linked table in Datasheet view after you have imported them into Access.
Number of columnsThe number of source columns cannot exceed 255, because Access does not support more than 255 fields in a table.
Blank columns, rows, and cellsDelete all unnecessary blank columns and blank rows in the Excel worksheet or range. If there are blank cells, try to add the missing data.
Error valuesIf one or more cells in a worksheet or range contain error values, correct them before you start the import operation. Note that if a source worksheet or range contains error values, Access inserts a null value in the corresponding fields in the table.
Data typeYou cannot change the data type or size of the fields in the linked table. Before you start the linking operation, you must verify that each column contains data of a specific type.

We highly recommend that you format a column if it includes values of different data types. For example, the FlightNo column in a worksheet might contain numeric and text values, such as 871, AA90, and 171. To avoid missing or incorrect values, do the following:

Right-click the column and then click Format Cells.

On the Number tab, under Category, select a format.

Click OK.
First rowIf the first row in the worksheet or named range contains the names of the columns, you can specify that Access should treat the data in the first row as field names during the link operation. If there are no column names in the worksheet, or if a specific column name violates the field naming rules in Access, Access assigns a valid name to each corresponding field.
  1. Exit the source file, if it is open.

Prepare the destination database

  1. Enter the database in which you want to create the link. Make sure that the database is not read-only and that you have the necessary permissions to make changes to it.
  1. If you don’t want to store the link in any of your current databases, produce a blank database: Pick the File tab, press New, and then select Blank Database. Note, if you’re using Access 2007, click the Microsoft Office Button and then click New.

You are now ready to start the linking operation.

Create the link

  1. The location of the import/link wizard changes minimally based upon your version of Access. Choose the steps that match your Access version:
  • If you’re using the latest version of the Microsoft 365 subscription version of Access or Access 2019, on the External Data tab, in the Import & Link group, click New Data Source > From File > Excel.
  • If you’re using Access 2016, Access 2013, or Access 2010, on the External Data tab, in the Import & Link group, click Excel. Note: The External Data tab is not available unless a database is open.
  1. In the Get External Data – Excel Spreadsheet dialogue box, in the File name box, state the name of the Excel source file.

  1. Click Link to the data source by creating a linked table, and then press OK. The Link Spreadsheet Wizard starts and guides you through the linking process.
  1. On the first page of the wizard, choose a worksheet or a named range and pick Next.

  1. If the first row of the source worksheet or range includes the field names, pick First row contains column headings. Access uses these column headings to classify the fields in the table. If a column name contains particularly special characters, it cannot be applied as a field name in Access. For such cases, an error message appears which notifies you that Access will categorise a relevant name for the field. Choose OK to continue.

  1. On the final page of the wizard, elaborate a name for the linked table and then select Finish. If the table with the name you define is already established, you are asked if you want to replace the current table or query. Select Yes if you want to overwrite the table or query, or press No to elaborate another name. Access attempts to design the linked table. If the operation succeeds, Access presents the Finished linking table message. Enter the linked table and glance at the fields and data to verify with complete certainty that you notice the correct data in all the fields. If you spot error values or incorrect data, you need to troubleshoot the source data. For further information about how to troubleshoot error values or incorrect values, read the next section.

Top of Page

Troubleshoot #Num! and other incorrect values in a linked table

Even if you receive the message Finished linking table, you should access the table in Datasheet view to guarantee that the rows and columns illustrate the correct data.

If you see errors or incorrect data anywhere in the table, follow the right steps as described in the following table, and then try linking again. Remember that you cannot insert the values directly to the linked table, as the table is read-only.

IssueResolution
Graphical elementsGraphical elements in an Excel worksheet, such as logos, charts, and pictures, cannot be linked to in Access.
Display formatYou might have to set the Format property of certain fields in Design view to ensure that the values are displayed correctly in Datasheet view.
Calculated valuesThe results of a calculated column or cells are displayed in the corresponding field, but you cannot view the formula (or expression) in Access.
Truncated text valuesIncrease the width of the column in Datasheet view. If you still don’t see the entire value, it could be because the value is longer than 255 characters. Access can only link to the first 255 characters, so you should import the data instead of linking to it.
Numeric field overflow error messageThe linked table might appear to be correct, but later, when you run a query against the table, you might see a Numeric Field Overflow error message. This can happen because of a conflict between the data type of a field in the linked table and the type of data that is stored in that field.
TRUE or FALSE and -1 or 0 valuesIf the source worksheet or range includes a column that contains only TRUE or FALSE values, Access creates a Yes/No field for the column in the linked table. However, if the source worksheet or range includes a column that contains only -1 or 0 values, Access, by default, creates a numeric field for the column, and you will not be able to change the data type of the corresponding field in the table. If you want a Yes/No field in the linked table, ensure that the source column includes TRUE and FALSE values.
Multivalued fieldsAccess does not enable support for multiple values in a field, even if the source column contains a list of values separated by semicolon (;). The list of values will be treated as a single value, and placed in a text field.
#Num!Access displays the #Num! error value instead of the actual data in a field in the following situations:

If a source column contains a few numeric or date values in a column that contains mostly text values, the numeric and date values are not imported.

If a source column contains a few text values in a column that contains mostly numeric values, the text values are not imported.

If a source column contains a few text values in a column that contains mostly date values, the text values are not imported.

Do the following to minimise the instances of null values in the table:

Ensure that the source column does not contain values of different data types.

Format the columns in the Excel worksheet.

During the linking operation, select the right data type for each field. If the data type is incorrect, the resulting column might contain only #Num! values for all the rows of data.
Numeric values instead of date valuesIf you see a seemingly random five-digit number in a field, check to see if the source column contains mostly numeric values but also includes a few date values. Date values that appear in numeric columns get incorrectly converted to a number. Replace the date values with numeric values and then try linking again.
Date values instead of numeric valuesIf you see a seemingly random date value in a field, check to see if the source column contains mostly date values but also includes a few numeric values. Numeric values that appear in date columns get incorrectly converted to a date. Replace the numeric values with date values and then try linking again.


Top of Page

Leave a Reply

%d bloggers like this: