Tweet
<font color="blue">Is there an easy way to transfer stuff from Excel to Access? I REALLY don't want to have to enter all of this info again... </font>
-
-
Re: Excel ----> Access
Hope this is what you're looking for.
Convert a Microsoft Excel list to a Microsoft Access database
After you convert a list to Microsoft Access, you maintain the data only in Access. Changes you make to the Access database after the conversion do not affect the Microsoft Excel list.
To convert an Excel list, you must have Access installed. If the Convert to MS Access command does not appear on the Data menu in Excel, you need to install and load the AccessLinks add-in program.
Select a cell in the Excel list.
On the Data menu, click Convert to MS Access.
To create a new Access database for the list, click New database.
To add the list to an existing Access database, click Existing database, and then type the path to the database in the box under Existing database. To look for the database on your system or network, click Browse.
Click OK.
The Access Import Spreadsheet Wizard and Table Analyzer Wizard guide you as you permanently convert your Excel list to an Access database.
Notes
After the conversion, AccessLinks places a text box to the right of the original list stating that the list has been converted to Access data. The original data, however, does not change. -
Re: Excel ----> Access
Speaking of Excel I need a link to download it for Window-s XP. While your looking for way-s to do that, hope you can help me out. [img]/forums/images/graemlins/blush.gif[/img] Did you have to download Excel or it come ready on your pc?
I need to download it.Comment
-
Re: Excel ----> Access
<font color="blue">Thanks, Compry, appreciate the help. I tried it a few times before I realized that those instructions are for 2002 and I have 2003. [img]/forums/images/graemlins/frown.gif[/img]
I Googled and got some other instructions for what's supposed to be an easier way to import Excel data but it was not easier. I had a headache when I left work. [img]/forums/images/graemlins/frown.gif[/img]
I think part of the problem is the number of sheets I have in the workbook that I'm trying to import and the data that I want to pull from those sheets to include in the database. I'm getting a headache again just thinking about it. I'll try it some more when I go back to work on Monday.
I would play around with it at home, but stupid me, I opted not to get Excel because I didn't think I would need it. [img]/forums/images/graemlins/frown.gif[/img]
Thanks again for the help, though. </font>Comment
-
Re: Excel ----> Access
[ QUOTE ]
Speaking of Excel I need a link to download it for Window-s XP. While your looking for way-s to do that, hope you can help me out. [img]/forums/images/graemlins/blush.gif[/img] Did you have to download Excel or it come ready on your pc?
I need to download it.
[/ QUOTE ]
<font color="blue">I don't think you can download it, I think you have to buy the program. You may be able to buy it online and download it. Unless you know someone that has it. </font>Comment
-
Re: Excel ----> Access
Go to your help menu, search via the index and you should get the correct instructions for the version you are using. [img]/forums/images/graemlins/70409-waytogo.gif[/img]Comment
-
Re: Excel ----> Access
² Afrocentriclady
you could use open office.. it's also with excel i think... and it's free, isn't it?Comment
-
Re: Excel ----> Access
Thank-s for you all-s help, I'll try both suggestion-s....
Don't know if it's free @ Hump , but I'm willing to pay if it cost, I really need it.Comment
Comment