I am reading a huge text file to transfer
it in access in five tables
I read a line, parse it then i create
the record with a recordset (no parameter so

Currently I'm connecting to several SQL and Oracle db's.  
In order to do this, I've added the Data Sources to the
PC that I'm working on, and then linked the tables.  I
would like to port this application to other PC's, but I

I need to automate the import process. I created a macro
and referenced the TransferSpreadsheet. Is there a way I
can pass the file name as a parameter. I want to create a
form button that by pressing will bring up the file browse

I am using ACCESS 2000 / Windows 2000 Professional.
Importing an Excel spreadsheet does not go through all the
step but completes before that.
This is what happens

I have two dates in excel spreadsheet. They are in format mm/dd/yyyy. They
are an enrollment date and withdraw date.  I need to import these into Access
table and will also have a 3rd field in Access table that will be number of
days.  This will have to be calculated....withdraw ...

I was wondering if you could help, this is for my A-Level
in ICT.
I have to create a database in which students details,
and course grades are stored. The database is required to

Rather than having a link to a specific document, my users
want to specifiy the path to a folder but when the link is
opened, the folders "pane" is expanded. Is there a way to
set the pane to not expand when the hyperlink is clicked?

Is there any way I can import a specific worksheet in an
Excel spreadsheet in to Access (2000)? Using
TransferSpreadsheet, I have a to specify a cell range,
but I cannot do that because the number of records will

I am trying to link to a public contact folder on my 2003 exchange server.
I get MAPI store "PTC Contacts" is known but not available in the current
profile.
I have checked my profile and turned off the cached setting and go directly

I have linked to excel and am finding the text cells are truncated in Access.
The data type is memo.
Any help is greatly appreciated.

Hi, When I run the following code, I see this error:
"Run-Time error '91': Object variable with block variable
not set"
Would someone be able to tell me what I'm doing wrong?

I have moved Access XP tables to Oracle 9i.
1.)Is there a way to connect to oracle using odbc through
VBA code, Can I use one connection variable for opening
and closing various recordsets? Any example will be

I have a fairly complex export routine that outputs data from access (an adp
actually) to a
Excel spreadsheet (v8 but actually deployed to and works happily with
Excel 2003).  This is done in code rather than as an export,  it is quite

my 2000 dates are being converted to 2020 when I import an
existing access table into a new database?  Any thoughts
on why and how to fix

I have a question. Can data be exported to an Excel form?
The scenerio is this: Need to export data from a query to
a pre-existing excel form the form contains headers,
formulas, and formating. We have clients that are