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
...
|
|
|
Importing Excel table with duplicate data
Tue, 28 Oct 2008 09:18:01 -0700
I have a table in Excel which is basically a list of companies and
information, like this:
Company1 Info1
Company1 Info2
Company1 Info3
Company2 Info1
Company2 Info2
Company3 Info1
Company3 Info2
Company3 Info3
Company3 Info4
I want a table in Access to look like this: ...
|
Fixed width export specs
Tue, 28 Oct 2008 09:13:01 -0700
We received extra spaces in our file when creating a fixed width export spec
that included spacing specifications in Access 2007. When we ran the exact
same spec in 2003 the output was correct. Does anyone have any idea what
could have happened in 2007? ...
|
Access Table Update from Active Directory
Tue, 28 Oct 2008 07:44:06 -0700
I have the following script that creates a table in Access of AD users. I'd
like to change the script so that instead of deleting and recreating the
table, it simply updates the table with changes, additions and deletions.
--------
Dim dbTableName
Dim dbPath
Dim LastLogin
Set objRoot = GetObject("LDAP: ...
|
