by: O'Donnell Tribunal |
last post by:
Hello Everybody,
I am using the TransferSpreadsheet method to import spreadsheets for
processing.
say my code looks like this:
DoCmd.TransferSpreadsheet acImport, 0, _
"tbltempImport1", ""...
|
by: Mick Hardy |
last post by:
Hi,
Has anyone seen this weird behaviour or have any suggestions or can
anyone reproduce it?
The history:
I converted a large third party DB from 97 to XP and it uses the...
|
by: Bob Hynes |
last post by:
Hi All,
In Access97 I'm using a TransferSpreadsheet acExport in vba code and
it errors when the spreadsheet I'm exporting does not exist. If I
create a empty spreadsheet with the name I use in the...
|
by: barma16 |
last post by:
I've hit a bit of a brick wall here, and could use some advice. I have
an Access application whose output is a four-tab Excel spreadsheet
where three of the four tabs are the result of database...
|
by: user_5701 |
last post by:
Hello, I'm getting an error with a Docmd.Transferspreadsheet line of
code:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel2000,
"tblTest", pathAndFilename, True
The above line...
|
by: Google Boy of Company C |
last post by:
Hi
Does anyone know why there seems to be a file name limit of 60
characters in Transferspreadsheet. I am exporting some records and this
is giving me severe grief.
I keep getting a message...
|
by: aleksandra_83 |
last post by:
Hello,
I have searched all over google groups and internet, but I have not
found a solution to this problem that has worked. The solutions I found
helped me single out the line that is causing...
|
by: DeanL |
last post by:
Hey Guys,
Does anyone know of a way to format the output of the
TransferSpreadsheet method in Access 97 so that the exported
spreadsheet has some formatting (column widths, row heights, cell...
|
by: Brad |
last post by:
Thanks for taking the time to read my question.
I want to use SQL in the TransferSpreadsheet Method, but I can't get it
to work.
I don't know why, because I've done a debug.pring on the same...
|
by: Icarus |
last post by:
I'm using TransferSpreadsheet to import an Excel file in to MS Access
2003.
DoCmd.TransferSpreadsheet acImport, 8, strTable, strFileName, True, ""
One of the columns in the Excel file is a...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|