TypeGuessRows setting
Thu, 30 Oct 2008 22:18:59 -0700
Hi All,
I am also facing the same problem. I think this problem can easily be reproduced ...
|
Search key not found
Thu, 30 Oct 2008 12:54:01 -0700
I am trying to import excel data to access. I have done extensive clean up
in excel including TRIM of all records, deletion of inconsistent data types,
and saving to excel 2007. However, when using the import excel file function
in Access 2007 I continue to get the message "Search key not found in any
reco ...
|
Importing table
Thu, 30 Oct 2008 11:49:02 -0700
I have a split database; the backend is located on a server in our home
office, the front end is stored on 40 usersâ?? local computers. When the users
try to run queries it takes a long time or times out because of the amount of
data and the linked tables. I now have unlinked the tables and use the
following ...
|
Import Excel to Access, define variable
Thu, 30 Oct 2008 11:46:55 -0700 (PDT)
How/where do one define variables, I've found many examples when
I'''ve ben lookin for how to import data from excel to access.
An example:
Dim rstImport As DAO.Recordset?
Thanks in advance
/Michelle
michellesihdu@brikks.com ...
|
Export Filter in a subform
Thu, 30 Oct 2008 08:33:02 -0700
hello,
i have a form with a subform i have cmdExcel
i want to export to excel after a filter in my subform thru cmdExcel.
is this possible?how can i accomplish this one? i am using access 2003
what would be my codes be look like?
thanks for any help, i appreciate. ...
|
Excel linked into Access (2003 fo both)
Thu, 30 Oct 2008 05:34:00 -0700
Hi,
I'm linking an Excel file to a Access DB. On one computer, I can modify the
data both way (from Excel to Access and vice versa) but on another computer
(same configuration), I can only change the data from Excel to Access, not
from Access to Excel.
In table view, I don't have the Add button availabl ...
|
Import External Data
Wed, 29 Oct 2008 09:00:17 -0700
Hello,
Is there a way to import data from (columns 1 and 2) of an external table
without having to import columns 3 and 4. I am only interested in data that
is located in Columns 1 and 2.
Thanks in advance for any advice on this. ...
|
|
|
Import Data
Wed, 29 Oct 2008 08:14:03 -0700
We have a main Access 2007 database with information data entered from hand
written field reports.
We would like to create an access form on table pcs for our field reps to
enter data into the form on the field site rather than filling out the form
in pen then having someone data enter the information back ...
|
Problem importing excel with nulls
Tue, 28 Oct 2008 21:36:00 -0700
I have an excel 2007 worksheet that i am trying to import in access 2007.
One of the coloums in my excel sheet may or may not have data in it for each
record. When I try to import it, I get an error message "subscript out of
range"
If I delete that column and then try to import into access it's fine.
It seems ...
|
Importing lg csv file into Access tbl
Tue, 28 Oct 2008 10:34:01 -0700
Hi
I'm trying to import data from Oracle into Access. I'm using a 'middle' tool
that help me run my SQL and it will show the output. My output data looks OK,
but when I try to save my results as .CSV so I can imported into Access tbl,
some of the data get split into multiple columns which cause the data to
...
|
