Discussion Locked

ACCESS 2000

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
PEOPLE SEND ME EXCEL SPREADSHEETS WITH DATA IN IT, THE DATA I NEED TO EXPORT TO ACCESS IS IN ONLY ONE COLUMN THAT VARIES, HOW DO I DO THIS SINCE I HAVE NO ADMIN PERMISSIONS TO THE DATABASE?

7 replies

by dklippert

A quick way to import data from Excel is to just copy the data (including headings) and then when you'rre at the Tables tab in Access, just Paste it. This will create an Access table that you can then Append etc.
If you mean that you do not have permission to make "Changes" to the other than to update data, you still should be able to Paste the data directly in an existing table. Match the number of fields then select the new row in the table and paste.

by vitheavirak.o

It mean that you need only one column from excel sheet. No problem, you can use access to create table and the table need to import from excel, you can select which colomn to import, not all from excel sheet. To do this, in MS Access you create new table using Import Table option => Change File Type to MS Excel => and select the MS Excel File you want to import, then click Import => Select Sheet contain data to import, then Next => Next => type new name for new Table, then Next => Here Import Speadsheet Wizard dialogue, click on the column you no need to import, then check "Do not import field(skip)". do like this whit the feel you don't want.=> Next => Next => Finish.
Enjoy what you want again, any question you can contact me directly via my e-mail. Feel happy to answer.

This discussion is closed to new replies.