Hello Everybody,
I am using the TransferSpreadsheet method to import spreadsheets for
processing.
say my code looks like this:
DoCmd.TransferSpreadsheet acImport, 0, _
"tbltempImport1", "" & strFileExtn, False, "Spreadheet1!A1:D30"
No Problem There.
However, if it looks like this:
DoCmd.TransferSpreadsheet acImport, 0, _
"tbltempImport2", "" & strFileExtn, False, "Spreadheet2 !A1:D30"
If fails.
What is the difference?
There is a space at the end of Spreadsheet2 I can't change the way
these are named.
So my query is this.
1 Can I get around the problem of TransferSpreadsheet choking when
there is a space at the end of the spreadsheet (tab) name.
2 How do I rename the sheet in Excel from Access.
Thanks a million guys.
O'Donnell 1 4155
Have you tried putting single quotes around the spreadsheet name like this:
DoCmd.TransferSpreadsheet acImport, 0, _
"tbltempImport2", "" & strFileExtn, False, "'Spreadheet2 '!A1:D30"
It's the appropriate reference syntax for a sheet name with spaces in Excel.
Jude sp*******@hotmail.com (O'Donnell Tribunal) wrote in message news:<a9**************************@posting.google. com>... Hello Everybody,
I am using the TransferSpreadsheet method to import spreadsheets for processing.
say my code looks like this:
DoCmd.TransferSpreadsheet acImport, 0, _ "tbltempImport1", "" & strFileExtn, False, "Spreadheet1!A1:D30"
No Problem There.
However, if it looks like this:
DoCmd.TransferSpreadsheet acImport, 0, _ "tbltempImport2", "" & strFileExtn, False, "Spreadheet2 !A1:D30"
If fails.
What is the difference? There is a space at the end of Spreadsheet2 I can't change the way these are named.
So my query is this.
1 Can I get around the problem of TransferSpreadsheet choking when there is a space at the end of the spreadsheet (tab) name.
2 How do I rename the sheet in Excel from Access.
Thanks a million guys.
O'Donnell This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Krishna A.M |
last post by:
Hi,
How do i add a hyperlink to a email id having special characters?
I tried the same , say mailto: test_&_send@hoohoo.com
IN the to box i can see only till test_ and the rest is omitted.
...
|
by: andrewflanders |
last post by:
I have an associative array of keys and values. I want to search a
string for the existance of keys and replace them with the values in
the array. The problem is that some of the keys resemble...
|
by: JMCN |
last post by:
hello
i have your basic select case question. i created a combo box and save
it as a query. so whenever the user selects the value and clicks the
export button, the select case should then export...
|
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: Gary Cobden |
last post by:
I have a problem with the following code, which leaves an instance of
Excel visible in Task Manager.
By a process of elimination I have got it down to the fact that
something in the...
|
by: Lokkju |
last post by:
I am pretty much lost here - I am trying to create a managed c++
wrapper for this dll, so that I can use it from c#/vb.net, however, it
does not conform to any standard style of coding I have seen....
|
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: JHNielson |
last post by:
I am having quite the unique problem trying to Export to Excel and I need ot find a solution within 3 hours. -- PLEASE HELP!
The system exports a file from the application that the users can make...
|
by: efrenba |
last post by:
Hi,
I came from delphi world and now I'm doing my first steps in C++. I'm
using C++builder because its ide is like delphi although I'm trying to
avoid the vcl.
I need to insert new features...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
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: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |