Welcome to the Excel Forum

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Please Register to Remove these Ads

Please Register to Remove these Ads



Reply
  #1  
Old 06-04-2009, 05:00 PM
Rick_Stanich's Avatar
Rick_Stanich Rick_Stanich is offline
Valued Forum Contributor
 
Join Date: 21 Nov 2005
Location: Phoenix AZ
MS Office Version:2000
Posts: 887
Rick_Stanich has been very helpful
Populating Tables from Excel

Please Register to Remove these Ads

I initially had some great help establishing tables for my database but I forgot what forum and the person that was so helpful. Sometimes, age has its rewards and sometimes age...um...what was I saying?

Now I am attempting to figure out how to populate the tables with data from Excel. I have read I can import and or link excel sheets but this seems to store them in the DB (correct me if Im wrong).

What I think I am facing is reading from an excel sheet and pupulating tables via VBA, Im pretty good with VBA just need to learn Access VBA commands.

Any help, hints, tips or examples is appreciated.

Attached is my DB and a sample excel file. There are no macros in either.
Attached Files
File Type: zip GM DataBase.zip (96.7 KB, 9 views)
__________________
Regards

Rick
NT 4.0, Office 2000
(aka Rick S.)

Last edited by Rick_Stanich; 06-04-2009 at 05:04 PM.
Reply With Quote
  #2  
Old 06-05-2009, 09:29 AM
split_atom18 split_atom18 is offline
Forum Contributor
 
Join Date: 23 Apr 2009
Location: Fredericksburg, IA
MS Office Version:Ultimate 2007
Posts: 126
split_atom18 Has established their mark in the community
Re: Populating Tables from Excel

Tells me your zip file is corrupt. Sorry

Dan
__________________
"I am not a rocket scientist, I am a nuclear engineer." - Split_atom18
If my advice has been helpful to you, then please help me by clicking on the scales and adding to my reputation, Thanks!
Reply With Quote
  #3  
Old 06-05-2009, 10:58 AM
Rick_Stanich's Avatar
Rick_Stanich Rick_Stanich is offline
Valued Forum Contributor
 
Join Date: 21 Nov 2005
Location: Phoenix AZ
MS Office Version:2000
Posts: 887
Rick_Stanich has been very helpful
Re: Populating Tables from Excel

Could be because I used WinRAR and renamed to ZIP.
Here is another copy. The file is actually a RAR file, if you have trouble viewing or extracting change the extension to RAR.

p.s.
I remembered the forum: www.access-programmers.co.uk/forums
Cross posted at: http://www.access-programmers.co.uk/...d.php?t=173364
Attached Files
File Type: zip GM DataBase.zip (80.3 KB, 15 views)
__________________
Regards

Rick
NT 4.0, Office 2000
(aka Rick S.)

Last edited by Rick_Stanich; 06-05-2009 at 11:40 AM. Reason: added cross post url
Reply With Quote


Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Forum Jump