I am trying to link an Access 2003 db to a sharepoint site and it works ok
when I link to a the main site or sub sites, but I can not link to a Folder
in a Library. Is this because a Folder is not a List or View object?

I am using the TransferSpreadsheet action in Access to send a table to an
excel spreadsheet. The table is made from an action query. At the query
level, a calculation is performed to create a new field that will result in a
numeric field that can contain up to 7 decimal places. ...

I am trying to export data from the address field in Access to Excel
spreadsheet. The data contains the special character that separate the
address lines.
For e.g. data export to address column of Excel (all lines into 1 column):

I am working with insurance cards, and due to new regulations we can no
longer print social security numbers.  The problem is that some of our
clients only want some of the digits printed to use as an identifier.  Other
clients are still printing the full social security number.  ...

I have an ACCESS MDB running on a SBS 2003 server.  I would like ot get
external data VIA a linked table which is currently on a WIN 98 PC on my
network.
But when I try to do the link - Access reports that for security reasons I

I've started on another database and I'm linking to an Excel spreadsheet
instead of importing it. (Learn something new, try something new.) Including
the header row, there are 209 rows and 37 columns in spreadsheet. When I
link, Access show 3,896 rows and 100 columns. I named the ...

I want to routinely import a txt file, but I only want some of the fields.
How can I do this? Do I have to use VBA?

I need to export a date as a mm/dd/yyyy from Access so that I can import this
txt file as a date. Whenever, I format my query, table, or field it comes out
as Date/Time field i.e. mm/dd/yyyy 00:00:00:0. Even when I change my criteria
on the export the date does not go through as ...

I need to export a largde amount of fields from Access into Excel. But a get
an errormessage (Errno: 3190) telling me there are too many fields (i.e >
255) defined in the query.
Any tips on how to export more than 255 fields into the same Excel worksheet?

I have a text file with about 100,000 rows and about 20 columns.
I want to import this text file as a new table. As a result, when I am in
Access and select the text file to import, Access automatically brings up the
import test wizard.

This question is for Access and Excel XP (2002).  I have an Excel Spreadsheet
(database) that I linked to Access for DB and updating features.  My unique
identifier (Key Field) is a Serial Number (SN).  The SN's contain 13 digits,
and in some instances digits and a (one) letter i ...

How do I convert a MS word file into a MS access file?

Thanks for taking the time to read my question.
I have a DB that I am currently designing.  I will have some data in Excel
that I want to import into a table.  The Excel file will contain ALL the
companies available.  I only want to import the NEW companies (The ones that

I have a spreadsheet that has comments in several cells
How do you import the comments? It just seems to not even see they are back
there.
I can edit them in excel but they dont seem to be transfered when i import

Question for Access and Excel XP (2002).  I have linked an Excel Spreadsheet
(Database) to Access for updating and other special Access functions.  The
Excel data contains a unique identifier (Key field) call Serial Numbers (SN)
that contains 13 characters.  Some SN contain ...