Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Retrieve data from Excel file (xls) using ODBC


Recommended Posts

Hi guys,


Has anyone been able to use excel as external source via ODBC ?


I keep getting:

"the odbc data source you have selected is not supported"


The setup is ok..My MDAC version is the latest..I don't get it.


I need values from an excel sheet and have to do it via ODBC because the manual says the Import script is not web compatible.



Link to comment
Share on other sites

How is a person using a web browser going to obtain info via ODBC from an Excel document that's on someone's hard drive? :confused:


Excel doesn't exist as a networked "resource" does it?

Link to comment
Share on other sites

Hello Ahunter3,


Indeed I can't use it via web. I just have to import records via normal Filemaker whenever I want to update the database in question.

My problem is solved now. I was trying to import records from excel via the windows ODBC driver.

But I figured out I can't do it like that. I have to Import records->File and then choose the excel and it recognizes automatically.

Now it's working.

But it's weird though..Should be able to import from excel via an odbc external data source and not only via the normal import->file->open (xls).


Thanks for your input :)



Link to comment
Share on other sites

I am not sure you can't import from Excel using ODBC (not positive that you can, either, I admit) but I'm almost certain that you would not be able to do so as a web-based guest.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use