Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
macdonald7 #1
Help importing excel file into Access DB
I need to import an excel file into an access database. I got the below code
from a forum on another site, but it is not working. I get an error with the
FROM clause. Help!
<cfquery name="imp_bat" datasource="m3db">
INSERT INTO imp_bat
SELECT *
FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0', 'Data
Source="c:\stats\stats.xls";Extended properties=Excel 5.0')...bat$
</cfquery>
macdonald7 Guest
-
Importing Text From Excel
I am running into a problem when I am trying to import text from an excel spreadsheet into InDesign. When I copy/paste it from Excel, I lose all of... -
Importing Fields from Excel into PDF Form
Kelly, You can setup PF-Merge to merge Excel into PDF in under 3 minutes. Reruns of changed data is setup in seconds! PF-Merge will also... -
Importing Excel data
On each import FM 5.5 crashes on the last record to import! e.g. dummy.xls contains of 21 records - FM crashes on the last ( 21st ) or takes... -
Data Access Problem when importing custom file
Hi, I have an aspx file that creates a custom class object and calls a method which should return a DataSet. It throws a: Description: The... -
Renaming Excel file linked to Access form
I created an Access form linked to an Excel file that I need to e-mail to others. When they rename the Excel file and try to click on the Access... -
Typheous #2 Re: Help importing excel file into Access DB
I believe for that to work you would need excel installed on the server, but I could be wrong. you may want to use emerle's CFX_excel2Query tag
Typheous Guest
-
jorgepino #3 Re: Help importing excel file into Access DB
your best bet would be to open the MSacess file and do an Import.
jorgepino Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
