TransferSpreadsheet - import non adjacent spreadsheet ranges
Mon, 4 Aug 2008 20:19:00 -0700
Hi Group,
I am using TransferSpreadsheet to import excel data into access.
This works fine as long as I can supply a single data range (ie
"data$A2:AI50")
How do I supply a series of non-adjacent cell ranges?(eg
"data$A10:AI10,A13:AI13,A51:AI96")
I have tried the text above and it gives the errror
...
|
>> Importing from SQL
Mon, 4 Aug 2008 14:08:03 -0700
Hi, using Access 2003. I want to import data from SQL. If I import to tables
that do not have any indexes the process takes a little over 2 hours with the
database building to 575 MB. When the Access database has indexes in the
tables the transfer fails because the database builds to over 2 GB during the
tra ...
|
subscript out of range
Mon, 4 Aug 2008 06:46:02 -0700
We import a text file into an access table, then we import an excel
file into another access table. we get the "subscript out of range" error
message. we close access and open it again, then the excel file imports
fine. any
ideas on a fix for this?
thanks
willy
...
|
Only one user can acces mdb file at a time
Mon, 4 Aug 2008 06:43:00 -0700
I have linked an mdb file to a SQL server for use in Crystal Reports. We have
three programmers that need to use this mdb file but only one of us can use
it at a time. The others will get a file is in use error from Crystal
Reports. I heard I would need to set permissions in Access to allow mulitple
users of ...
|
Truncating a CLOB field to 255 Chars
Mon, 4 Aug 2008 06:04:02 -0700
Hi
I'm trying to import a DB2 Table into access for user interogation.
I've tried Importing the Data via ODBC, Attaching a linked table (again ODBC).
in both occassion the CLOB field comes across as a TEXT field and thus
trucates the field to 255 chars.
I've tried creating the table with a MEMO field and ...
|
automate fax/e-mail data entry into access
Sun, 3 Aug 2008 17:14:51 -0700 (PDT)
Hi:
I?m wondering if anyone can explain how to do the following.
I?m trying to set up a ?paperless? office, in which all documents
regarding clients are constructed within the office database (using
MSAccess2003), or are received via Fax or e-mail.
I?m wondering what is the best way to reference the ?received? ...
|
DCount problem...
Sat, 2 Aug 2008 22:09:00 -0700
I am importing a spreadsheet into a table in my database, however I need to
check the data that's in the table prior to importing the spreadsheet. I
can't seem to get the DCount function to work for me. Can anyone spot what
my problem may be? Here's the code:
'Check to see if this monthly is already in t ...
|
|
|
Output query data to a Word document to mail merge for address lab
Sat, 2 Aug 2008 19:20:00 -0700
Can't get a query to merge into a word document that is already set up as
address labels using a macro to complete the process. ...
|
Does anyone know how to automate the collect data via email wizar.
Sat, 2 Aug 2008 13:19:00 -0700
I am trying to automate sending of emails from Access 2007. Each time I use
CollectDataViaEmail, it forces me through a 6-step wizard and I would like to
atomate that process. My selections on each of the 6-steps or screens are
always the same. Does any one know how this can be done? Thank you in advance. ...
|
How to connect to oracle odbc data source
Sat, 2 Aug 2008 13:34:56 -0400
I need to connect to an oracle data source via ODBC.
Using conventional ODBC setup forces the user to enter user id and password
when the application opens.
Can someone provide the access code that will connect to the data source
instead of the user?
I have the values I just don't know how to set up the VB ...
|
