Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

excel

Status
Not open for further replies.
missmolly

missmolly

Technical User
May 25, 2002
7
0
0
IE


have just recieved an excel file with info on over 500 clients, normally new clients are entered in the database using a form,as you can imagine this is a lot of work, is there any way that I can use the info in the excel file to simplify the job???
 
Sort by date Sort by votes
You can import the excel file into Access and use an append query to copy the records to your client table in Access.

If you need further assistance, give me some more details and I can give you more specific instructions.

Good Luck!!!

L. [thumbsup2] "The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents."
-Nathaniel Borenstein
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

OCM
  • Question
Populate access table from excel
Replies
6
Views
233
OCM
OCM
TheresAlwaysAWay
  • Locked
  • Question
Convert PDF to Excel spreadsheet within Access 2
Replies
10
Views
189
TheresAlwaysAWay
TheresAlwaysAWay
MattGreer
  • Locked
  • Question
MS Access to Excel: Processing of Original Data 1
Replies
4
Views
53
Darrylles
Darrylles
lameid
  • Locked
  • Question
Access Report (Letter) With Excel Charts - Best Practice?
Replies
9
Views
53
SkipVought
S
Thadius
  • Locked
  • Question
Preventing duplicates in Excel VBA
Replies
2
Views
42
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top