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!

converting excel to access

Status
Not open for further replies.
jassrs

jassrs

Technical User
Jul 10, 2003
56
0
0
US
Can anyone help?
I am trying to convert an excel worksheet to a "dummy" access database. I have office 2000 and trying to do the conversion with a vb6 app. Can anyone show me how to do this?
 
Sort by date Sort by votes
within access just import that xls doc..

it should take you through a wizard
 
Upvote 0 Downvote
ok that was vague... right mouse button in the tables area of your database and click import
 
Upvote 0 Downvote
I knew how to do that... I had to find a way to do it through my visual basic application. (which I did)
I had to keep the documents "behind the scene" and have the user convert it through her application. Thanks for the respone though.
 
Upvote 0 Downvote
Here is a post that may be useful:

Thread222-683416

Swi
 
Upvote 0 Downvote
HAHA!! I'm so sorry..

I walked away from my desk for a min and didn't realize what thread I was in!!

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
graph with access database - im on vb6 2
Replies
10
Views
188
strongm
strongm
sal21
  • Locked
  • Question
ARRANGE this Access coe to vb6
Replies
4
Views
80
strongm
strongm
Swi
  • Locked
  • Question
Read Excel Sharepoint File
Replies
0
Views
61
Swi
Swi
2009luca
difficult to crteate a query very complicated 1
Replies
9
Views
615
Andrzejek
Andrzejek
2009luca
  • Locked
  • Question
USE find instead to loop
Replies
2
Views
112
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top