Midwest Illinois, Indiana, Michigan, Ohio, and Wisconsin

Contact list is (sort of) available!

Thread Tools
 
Search this Thread
 
Old Sep 20, 2002 | 09:01 PM
  #1  
PurpleHaze95's Avatar
Thread Starter
Registered User
 
Joined: Jul 2002
Posts: 652
From: Southwest MI
Contact list is (sort of) available!

OK, I put the contact info from this thread into a nice database so it would be searchable. The problem? I use Lotus Approach and after I had put the whole thing together I discovered that I couldn't save it as a file for MS Access! So it's available as three file types:

an .APR file, which is for Lotus Approach
a .XLS file, which is MS Excel
a .TXT file, which opens right in your browser or can be opened in Notepad

If you discover that your contact information is incorrect, please change your name or your email so I don't have to redo anything.

Last edited by PurpleHaze95; Sep 22, 2002 at 09:28 PM.
Old Sep 21, 2002 | 11:45 AM
  #2  
Grover's Avatar
Registered User
 
Joined: May 1999
Posts: 1,173
From: Portage, MI USA
You should be able to import the Excel file into a table into Access and then create forms and reports to be able to search the data.
Old Sep 22, 2002 | 09:26 PM
  #3  
PurpleHaze95's Avatar
Thread Starter
Registered User
 
Joined: Jul 2002
Posts: 652
From: Southwest MI
Originally posted by Grover
You should be able to import the Excel file into a table into Access and then create forms and reports to be able to search the data.
I can't figure out how to make Access (I'm currently running Office 97) do that, it's not a menu option that I can find. (Although I confess I didn't spend ages looking either.) So if you know how then be my guest.

Last edited by PurpleHaze95; Sep 22, 2002 at 09:29 PM.
Old Sep 22, 2002 | 10:16 PM
  #4  
DJCobol's Avatar
Registered User
 
Joined: Nov 2000
Posts: 795
From: In exile
Access database

There is the Excel Spreadsheet imported into a simple table in Access. If anyone else wants to expand on that by adding more tables or making it into a webpage, be my guest.
Old Oct 2, 2002 | 07:38 AM
  #5  
Grover's Avatar
Registered User
 
Joined: May 1999
Posts: 1,173
From: Portage, MI USA
What version of Access did you use Chris?
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
RUENUF
Cars For Sale
1
May 25, 2016 08:10 PM
RUENUF
South Atlantic
4
Mar 13, 2016 03:39 PM
ChrisFrez
2010 - 2015 Camaro News, Sightings, Pictures, and Multimedia
0
Mar 17, 2015 07:31 AM
squarehead
General 1967-2002 F-Body Tech
7
Jan 15, 2015 07:02 PM




All times are GMT -5. The time now is 06:17 AM.