answersLogoWhite

0

Can you import a primary key in Excel?

Updated: 8/20/2019
User Avatar

Wiki User

11y ago

Best Answer

You can import the field that is the primary key, along with all the other fields. As Excel is not really a database program, it doesn't have quite the same facilities to recognise primary keys. You can still use it as the main field to sort the data on, and also specify other fields to sort on.

You can import the field that is the primary key, along with all the other fields. As Excel is not really a database program, it doesn't have quite the same facilities to recognise primary keys. You can still use it as the main field to sort the data on, and also specify other fields to sort on.

You can import the field that is the primary key, along with all the other fields. As Excel is not really a database program, it doesn't have quite the same facilities to recognise primary keys. You can still use it as the main field to sort the data on, and also specify other fields to sort on.

You can import the field that is the primary key, along with all the other fields. As Excel is not really a database program, it doesn't have quite the same facilities to recognise primary keys. You can still use it as the main field to sort the data on, and also specify other fields to sort on.

You can import the field that is the primary key, along with all the other fields. As Excel is not really a database program, it doesn't have quite the same facilities to recognise primary keys. You can still use it as the main field to sort the data on, and also specify other fields to sort on.

You can import the field that is the primary key, along with all the other fields. As Excel is not really a database program, it doesn't have quite the same facilities to recognise primary keys. You can still use it as the main field to sort the data on, and also specify other fields to sort on.

You can import the field that is the primary key, along with all the other fields. As Excel is not really a database program, it doesn't have quite the same facilities to recognise primary keys. You can still use it as the main field to sort the data on, and also specify other fields to sort on.

You can import the field that is the primary key, along with all the other fields. As Excel is not really a database program, it doesn't have quite the same facilities to recognise primary keys. You can still use it as the main field to sort the data on, and also specify other fields to sort on.

You can import the field that is the primary key, along with all the other fields. As Excel is not really a database program, it doesn't have quite the same facilities to recognise primary keys. You can still use it as the main field to sort the data on, and also specify other fields to sort on.

You can import the field that is the primary key, along with all the other fields. As Excel is not really a database program, it doesn't have quite the same facilities to recognise primary keys. You can still use it as the main field to sort the data on, and also specify other fields to sort on.

You can import the field that is the primary key, along with all the other fields. As Excel is not really a database program, it doesn't have quite the same facilities to recognise primary keys. You can still use it as the main field to sort the data on, and also specify other fields to sort on.

User Avatar

Wiki User

11y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

11y ago

You can import the field that is the primary key, along with all the other fields. As Excel is not really a database program, it doesn't have quite the same facilities to recognise primary keys. You can still use it as the main field to sort the data on, and also specify other fields to sort on.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Can you import a primary key in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Would you import users from csv files into Excel?

Excel has no relation to Active Directory. If you have permission to import, you should be able to import directly from a CSV file, and not have to import into Excel first. Check with your systems or network administrator to see how your specific network Active Directory is configured.


What can you import from Microsoft Excel 2007?

It depends on where you are exporting to if you are tyring to import from Excel. Generally, you can import Excel data to many applications, but the target application will determine what will transfer from Excel and how the data will disply in the target application.


How do you import Excel spreadsheet into HTML?

You do not really import an excel spreadsheet into HTML. You can SaveAs and select HTML as an option.


How do you import data from word to Excel?

You do not really import data from Word, but you can cut and paste from Word to Excel. If you like, you can embed the word document in an Excel worksheet.


What does an identifier do in Excel?

When used as a database, an identifier in Excel identifies a record, so it acts like a primary key field. You can then find records easier.


How do you import contacts to groups in way2sms from excel sheet?

how we import contacts by files


What is Mongolia's key import?

Machinery is Mongolia's key import, followed by fuel.


What happens if you don't assign a primary key field in Microsoft Excel?

Excel is primarily a spreadsheet, not a database, so you do not set primary keys in it. That would be something you would do in a program like Access. Setting a primary key ensures that there is a unique value in each record, meaning that record can always be uniquely identified. Without a primary key set, it is possible to end up with duplicated data and it can be harder to find data. Primary keys are also used in creating relationships, so that is more difficult to do without one.


Can you import Microsoft Word into Microsoft Excel?

Yes


Which field MS Access will not allow you to delete?

A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.


How do you import from Excel to Google Maps?

I don't think there is a direct way, but some websites offer something very close to that (copy and paste from Excel Spreadsheet or Save as CSV and import).


Excel import multiple excel files software with license?

Use Asap Utilities, is free for personal use and, beside many other things, you can easily import many files in one.