Hi, I have a database that so far is working fine. Now I got a new challenge
I have to put this database in 2 other locations, these locations will have
the database running with their data, but I need to have access to the data
from their databases in my database.

I am using the macro "TransferSpreadsheet" to import Excel files to my Access
Database. The issue is that I have to keep the location of these input files
fixed to a predefined location. Can I use some function through which I can
browse and select the location of my files or ...

As well as specifying the file name is it possible to specify the sheet as
well?

I wish to export my table contents to a txt file where the Field Delimiter
should be semi-colon (;) and the Text Qualifier should be a double-quote (")
but where the field's lenght must be preserved.
ex: txt file should look like :

I am a novice user.  I have a database with about 100 dates that I want to
merge to an annual calendar, fill in a name, and print.  Can I do this within
access or is their another software that will work easily with Access?

After reading several post I decided to try use the split function to import
data from my comma delimited text files.  I was using the TransferText method
which works like a charm except that I need to add custom field data for each
record.  Can I do that using the TransferText ...

I am using Access 2003 and trying to import a table from Excel and keep
getting an error message but am unsure what the error relates to.  I have
tried to change various aspect (data types etc) but still get the error.
In my Access database I have some fields which are checkbox ...

I want to create a dataset and save it as a csv file.  To create the correct
data set I have had to use a UNION query.  Everything is working fine up to
the point of exporting.
If I try to export it as a text file I get the error message "Too few

I wrote a batch file that upon open of the FE checks the version of the
client to that of the server and if it is not up to date it copies over the
new client, everything works great except for the fact that I have linked
tables. When the client opens I have to select the machine ...

What is the easiest way to create a link between access 2003 databse and
excel 2003. i want to import data from excel to access and export from access
to excel.
entrepreneur4real@yahoo.com

After selecting ODBC datbases as the file type for to import a table. The
data source select dialogue box fails to display. I've been using the
function for quite some time and have never had this issue. Any thoughts?

All of the discussions about merging or appending data in tables fail to
mention the primary key and other related tables. I am trying to write a
routine to update a client's backend file to the latest revision and I am
runnining into the problem of making sure that the old ...

I have an excel spreadsheet with a field with the time format  "7:00:00 AM".
When I import this spreadsheet, the value showing in the Import Spreadsheet
Wizard is .29166666667.  Each time value has a different number similar to
this representing the cumulative percentage of the ...

Ok, so I've got code that will go through the open file dialogue in access and now I'm trying to save the value of that file and feed it into a macro that does the transfer text delimited.  I keep getting this error that the expression I'm entering is the wrong data type for the ...

When copying/pasting or exporting an Access table into Excel, the longest
text fields are truncated in the Excel version after a set number (256
possibly) of characters. Excel cells definitely have capacity for
more--anybody have a workaround? TIA