import customer names to northwind database.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to import customer names from a txt file to the northwind
database. The key field keeps stopping the impot.
 
Does your text file include a unique 5-character CustomerID for each
customer?
 
I added the 5 character CustomerID for each customer. It gave me a rule
validation error. I removed the 5 character requirement from the table and
the customers form and it still gives me the validation error. I haven't
been able to find out what rule is being violated.
 
The only other thing I can see is that CompanyName is a required field,
so you'll get an error if you try to import any customers who don't have
companies.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can ASPNET access the Northwind database 1
See image from northwind 3
LINQ and MSAccess Northwind? 3
Importing a file from another database 2
for an ebike biz: Northwind without existing customers etc 0
Importing a 'non-standard' file type 1
Modify Northwind 0
Select unique products per customer? 7

Back
Top