Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Connecting to excel worksheet

  
   Database Help (Home) -> Visual Basic -> DAO RSS
Next:  Add an empty string to a field  
Author Message
RickR

External


Since: Oct 16, 2003
Posts: 1



(Msg. 1) Posted: Thu Oct 16, 2003 12:51 pm
Post subject: Connecting to excel worksheet
Archived from groups: microsoft>public>vb>database>dao (more info?)
I'm trying to connect to an excel worksheet with a VB app
using DAO and when trying to open the sheet with the Set
db OpenDatabase statement I receive the error 3343 that
the database is in an unrecognized format. I believe it is
looking for a file extension of mdb but the excel
worksheet has .xls extension. Any suggestions would be
greatly appreciated. Thanks

 >> Stay informed about: Connecting to excel worksheet 
Back to top
Login to vote
Paul Clement

External


Since: Sep 02, 2003
Posts: 236



(Msg. 2) Posted: Thu Oct 16, 2003 4:17 pm
Post subject: Re: Connecting to excel worksheet [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Thu, 16 Oct 2003 09:51:50 -0700, "RickR \(newbie\)"
<rickrobinson2000SpamShouldBeDeleted DeleteThis @yahoo.ca> wrote:

¤ I'm trying to connect to an excel worksheet with a VB app
¤ using DAO and when trying to open the sheet with the Set
¤ db OpenDatabase statement I receive the error 3343 that
¤ the database is in an unrecognized format. I believe it is
¤ looking for a file extension of mdb but the excel
¤ worksheet has .xls extension. Any suggestions would be
¤ greatly appreciated. Thanks

Could you post your code and identify where the error is occurring?


Paul ~~~ pclement DeleteThis @ameritech.net
Microsoft MVP (Visual Basic)

 >> Stay informed about: Connecting to excel worksheet 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Problem with DAO (Import from Excel to Access)! :( - Hi, I am novice and I have problem. I need import some data with Excel file to Access. Problem introduces as follows: In Excel(first sheet) i have data: "TYTUL" - column "A" "NAZWISKO" - column "B" "IMIE&quot...

Using Jet data control to write numbers to an excel spread.. - Hi, I'm currently using the vb data controls to write numbers to excel spreadsheets using the Jet driver. Unfortunately, even though the data being sent to the spreadsheet is numbers, excel has a nasty habit of showing them as text, requiring them t...

DAO 3.6 record locking - Hi, Is it possible to programmatically lock a single record in a VB application using DAO 3.6? I would like to lock users' records when they log on to the app. Later I can check if a user's record is locked to see if they are logged in or not. (I....

Fixes for VB4 or DAO 3.0 - I've got VB4 (32-bit) and it seems to use DAO 3.0. Is there a service pack for either of these that I can use? I'm having issues with DAO and > 2GB of RAM on the machine, and don't want to have to move to a newer version of VB if I can help it, just t...

Jet error - I've just started getting this error message on a seemingly random basis. 'The Microsoft Jet database engine does not recognize 'CID' as a valid field name or expression.' CID is a text field, and it is a valid column name. The line of code that..
   Database Help (Home) -> Visual Basic -> DAO All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]