*ping* Jonlumb
- Mrs Redeyes
- Posts: 4741
- Joined: Tue Jul 15, 2008 12:00 am
- Location: I'm Over Here!!
*ping* Jonlumb
Mr Red suggested you might know if there is a way to import data from an Excel spreadsheet into an Access database. I have some information which has been half-entered into Excel which would be much better in a proper database and I'll be entering the rest of the data into Access but I'd rather not hand-type all the stuff that's already been done if there's another way.
Any help you can offer would be mondo appreciated <!--emo&:)--><img src='http://i2.ifrm.com/html/emoticons/smile.gif' border='0' style='vertical-align:middle' alt='smile.gif' /><!--endemo-->
--------------------
<div class='signature'>"Why do the people who know the least, know it the loudest?"
"Illegitmi non carborundum est!"
<img src='http://i176.photobucket.com/albums/w165 ... Icon-1.jpg' border='0' alt='user posted image'>
Any help you can offer would be mondo appreciated <!--emo&:)--><img src='http://i2.ifrm.com/html/emoticons/smile.gif' border='0' style='vertical-align:middle' alt='smile.gif' /><!--endemo-->
--------------------
<div class='signature'>"Why do the people who know the least, know it the loudest?"
"Illegitmi non carborundum est!"
<img src='http://i176.photobucket.com/albums/w165 ... Icon-1.jpg' border='0' alt='user posted image'>
"Why do the people who know the least, know it the loudest?"
"Illegitmi non carborundum est!"
"Illegitmi non carborundum est!"
*ping* Jonlumb
I will have a look when I get home, but I suspect there will be a Wizard of some description for doing it.
Which version of Excel / Access are you using?
--------------------
<div class='signature'> I can feel bits of my brain falling away like pieces of wet cake.
Which version of Excel / Access are you using?
--------------------
<div class='signature'> I can feel bits of my brain falling away like pieces of wet cake.
- Mrs Redeyes
- Posts: 4741
- Joined: Tue Jul 15, 2008 12:00 am
- Location: I'm Over Here!!
*ping* Jonlumb
Fabby, Thanks <!--emo&:)--><img src='http://i2.ifrm.com/html/emoticons/smile.gif' border='0' style='vertical-align:middle' alt='smile.gif' /><!--endemo-->jonlumb wrote:Which version of Excel / Access are you using?
Excel is "2002 (10.6847.6845)" - whatever that means.
I suspect Access will be the same version although I haven't actually got hold of a copy of it yet <!--emo&:(--><img src='http://i2.ifrm.com/html/emoticons/sad.gif' border='0' style='vertical-align:middle' alt='sad.gif' /><!--endemo-->
--------------------
<div class='signature'>"Why do the people who know the least, know it the loudest?"
"Illegitmi non carborundum est!"
<img src='http://i176.photobucket.com/albums/w165 ... Icon-1.jpg' border='0' alt='user posted image'>
"Why do the people who know the least, know it the loudest?"
"Illegitmi non carborundum est!"
"Illegitmi non carborundum est!"