Linking Excel spreadsheet to Access

[jalmar]

Hello again:

My second question is:

I am linking an excel spreadsheet into Access, I have it linked and at first had problems getting the information imported into Access-it wasn't importing-I had a msg in the populated fields which read #NUM- I was told to use quotations before and after the numbers in Excel and it would import correctly, which did happen but when I run my query off that linked table, it creates far too many records......and information is duplicated far too many times. Can anyone help me with this problem. I am trying to import dates into an access table. The spreadsheet lists many different trust numbers and then dates these trusts were signed~I link the spreadsheet to Access and it pulls the information in as is listed in Excel but when I run the queries, the first record contains all the information but dates are entered where they shouldn't be and then there are at least 1400 records with the same information. Again...hope this is clear and someone is able to help, I've been working on this for days.

Thanks in advance

[maxamis4]

Linking has never been my preferred method to manage excel. If I were you I would import it. If there is a specific format you want excel to keep then I would create an auto number field so that the data imports in the order that you have it in excel. Just do an import and find the excel spread sheet you want. Right click on the white work space under table right click and import.


Good luck

[jalmar]

Linking has never been my preferred method to manage excel. If I were you I would import it. If there is a specific format you want excel to keep then I would create an auto number field so that the data imports in the order that you have it in excel. Just do an import and find the excel spread sheet you want. Right click on the white work space under table right click and import.


Good luck

I did that also but the queries are still not ran right. Could it be because the information is duplicated~some families have 25 different trusts but they all have different numbers assigned

[maxamis4]

Well you have to ask yourself, what identifies this data you want to extract that is unique to the information you want to retrieve. send it to me if you want me to take a look at it. jpgomez80 at gmail dot com, make sure you zip it and then change the extension from zip to .doc

[jalmar]

Well you have to ask yourself, what identifies this data you want to extract that is unique to the information you want to retrieve. send it to me if you want me to take a look at it. jpgomez80 at gmail dot com, make sure you zip it and then change the extension from zip to .doc

hee hee-I"m an idiot-how do you zip?

[maxamis4]

you should be able to right click on the file and an option will be there that says send to compress

that should do it

[NeoPa]

you should be able to right click on the file and an option will be there that says send to compress

that should do it

You will need to install some ZIPping software I think.
Try WinZip as just one place to get something quickly.