Menu

Do a duplicates check during the CSV import

0 votes

I have 25,000 lines of data to import and I would like the dbFront CSV import to automatically manage the duplicate checks.

in How To by (3.6k points)
recategorized by

1 Answer

0 votes
 
Best answer

There are three options when importing data:

  1. Use the dbFront Quick Import Wizard,
  2. Create an Import Batch Process in dbFront for user driven managed imports,
  3. Import directly with your database-specific tools.

For 25,000 rows of data I would suggest the option is to use the tools provided by your SQL server to import the data directly. That would be most appropriate if you have a very large amount of data that needs to be imported by administrators.

For SQL Server: https://dbfront.com/qa/202/how-do-i-import-csv-data-into-sql-server-via-dbfront

by (44.5k points)
selected by
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
 |
Powered by Question2Answer
...