Excel to Access

[choolie 0]

Hi All. following some suggestions elsewhere in other threads I started an making an excel spreadsheet of my coins. It was fairly simple to start with and I was even managing to do some interesting things like a drop down list for the gradings. I have noticed however it does not seem to work well with photos, although you can include them as a file link, you cannot include them as the contents of a cell. Access seems better for this sort of thing, I was trying to the spreadsheet to access but not having much luck anyone know how to do this?

[The Future 11]

It should be fairly straight forward. here are two ways I can think of:

1) In Access select File>Get External Data>Import Then find your spreasheet from the directory ensuring you select files of type includes Excel files. Then follow the import wizard instructions.

2) an easier way might be just to open a new table in data sheet view, copy the Excel worksheet contents and and then select all in your access table and paste. You will have to set the headings/formats up again though.

[choolie 0]

It should be fairly straight forward. here are two ways I can think of:

1) In Access select File>Get External Data>Import Then find your spreasheet from the directory ensuring you select files of type includes Excel files. Then follow the import wizard instructions.

2) an easier way might be just to open a new table in data sheet view, copy the Excel worksheet contents and and then select all in your access table and paste. You will have to set the headings/formats up again though.

Thanks I will try that and see how it goes, cheers future

[Peckris 579]

It should be fairly straight forward. here are two ways I can think of:

1) In Access select File>Get External Data>Import Then find your spreasheet from the directory ensuring you select files of type includes Excel files. Then follow the import wizard instructions.

2) an easier way might be just to open a new table in data sheet view, copy the Excel worksheet contents and and then select all in your access table and paste. You will have to set the headings/formats up again though.

Thanks I will try that and see how it goes, cheers future

In FileMaker Pro I have an external database that has scans of both sides of each coin; linking to my main coins database I have a unique relational identifier. Using that relationship field I can display each coin's pictures in one layout of my main database (or - which is the main point - any other database too), without ever having to import them.

[choolie 0]

It should be fairly straight forward. here are two ways I can think of:

1) In Access select File>Get External Data>Import Then find your spreasheet from the directory ensuring you select files of type includes Excel files. Then follow the import wizard instructions.

2) an easier way might be just to open a new table in data sheet view, copy the Excel worksheet contents and and then select all in your access table and paste. You will have to set the headings/formats up again though.

Thanks I will try that and see how it goes, cheers future

In FileMaker Pro I have an external database that has scans of both sides of each coin; linking to my main coins database I have a unique relational identifier. Using that relationship field I can display each coin's pictures in one layout of my main database (or - which is the main point - any other database too), without ever having to import them.

Hi Peckris,

presumably I would be able to do the same thing in access? I don't have filemaker pro, is it an expensive programme? you think it is better? I now seem to be getting somewhere with access I have managed to make a field for attachments where I can put a photo but I am learning how to use the programme at the same time. no doubt I will have further questions, but pleased with my progress today

[Peckris 579]

It should be fairly straight forward. here are two ways I can think of:

1) In Access select File>Get External Data>Import Then find your spreasheet from the directory ensuring you select files of type includes Excel files. Then follow the import wizard instructions.

2) an easier way might be just to open a new table in data sheet view, copy the Excel worksheet contents and and then select all in your access table and paste. You will have to set the headings/formats up again though.

Thanks I will try that and see how it goes, cheers future

In FileMaker Pro I have an external database that has scans of both sides of each coin; linking to my main coins database I have a unique relational identifier. Using that relationship field I can display each coin's pictures in one layout of my main database (or - which is the main point - any other database too), without ever having to import them.

Hi Peckris,

presumably I would be able to do the same thing in access? I don't have filemaker pro, is it an expensive programme? you think it is better? I now seem to be getting somewhere with access I have managed to make a field for attachments where I can put a photo but I am learning how to use the programme at the same time. no doubt I will have further questions, but pleased with my progress today

I would think that Access is probably very similar to FileMaker (FM, being originally Mac, is easier to get started with, is all). You would need to find out how different database "files" or "tables" RELATE to each other - it will be using a unique identifier, so one thing you could do is create a unique ID Number for each coin you have, then import a table of ID Numbers to your pictures database. Then in the Pictures database, make sure you have a layout that can display a minimum of two images - obverse and reverse - and that's where you will store your coin pictures. Then, back in your coins database, you create a similar layout, but instead of having the actual pictures, you link to the other database using the ID Number (it's a lot easier than it sounds!)

The good thing about this is, it means your basic coins database won't be too large, i.e. quicker to open and work with. (I just had a look at my own Pictures database, and it is 96MB so that too will easily fit onto the modern Flash drive. You can get a 1GB or 2GB for under £10 these days.)

[choolie 0]

It should be fairly straight forward. here are two ways I can think of:

1) In Access select File>Get External Data>Import Then find your spreasheet from the directory ensuring you select files of type includes Excel files. Then follow the import wizard instructions.

2) an easier way might be just to open a new table in data sheet view, copy the Excel worksheet contents and and then select all in your access table and paste. You will have to set the headings/formats up again though.

Thanks I will try that and see how it goes, cheers future

In FileMaker Pro I have an external database that has scans of both sides of each coin; linking to my main coins database I have a unique relational identifier. Using that relationship field I can display each coin's pictures in one layout of my main database (or - which is the main point - any other database too), without ever having to import them.

Hi Peckris,

presumably I would be able to do the same thing in access? I don't have filemaker pro, is it an expensive programme? you think it is better? I now seem to be getting somewhere with access I have managed to make a field for attachments where I can put a photo but I am learning how to use the programme at the same time. no doubt I will have further questions, but pleased with my progress today

I would think that Access is probably very similar to FileMaker (FM, being originally Mac, is easier to get started with, is all). You would need to find out how different database "files" or "tables" RELATE to each other - it will be using a unique identifier, so one thing you could do is create a unique ID Number for each coin you have, then import a table of ID Numbers to your pictures database. Then in the Pictures database, make sure you have a layout that can display a minimum of two images - obverse and reverse - and that's where you will store your coin pictures. Then, back in your coins database, you create a similar layout, but instead of having the actual pictures, you link to the other database using the ID Number (it's a lot easier than it sounds!)

The good thing about this is, it means your basic coins database won't be too large, i.e. quicker to open and work with. (I just had a look at my own Pictures database, and it is 96MB so that too will easily fit onto the modern Flash drive. You can get a 1GB or 2GB for under £10 these days.)

I see, I can see the benefits of such portability. I am not quite there yet but I will try that later once I have mastered the basics, my database is now coming along nicely I can see I am goint to find it indispensable.

Cheers

[choolie 0]

Ta-dah.

I would like to thanks Peckris for most of the field headings. The future for setting me on the first steps on my journey. Chris perkins for providing me with the platform to display my work. My mother and father for being such an inspiration to me. My dear wife for her loving patience and support. All other friends and supporters too numerous to mention. Who would have thought all those years ago that I would be standing here today having achieved all this. I thank you and dedicate this to you.

[Peckris 579]

Ta-dah.

I would like to thanks Peckris for most of the field headings. The future for setting me on the first steps on my journey. Chris perkins for providing me with the platform to display my work. My mother and father for being such an inspiration to me. My dear wife for her loving patience and support. All other friends and supporters too numerous to mention. Who would have thought all those years ago that I would be standing here today having achieved all this. I thank you and dedicate this to you.

Thanks for the kudos ! And it looks good - WTG choolie - I hope you and it will have a long and successful future together