I have a simple table, tblWholesaler, with Address, Address2, City, State,
Zip, Zip4, Phone, First, Middle, last; all are of text length 50 except:zip
of length 5, Zip4 of length 4, phone of length 10.
I will be receiving Excel files which have no specific naming convention, so

Afternoon,
I'm trying to have a linked excel spreadsheet update in access and in doing
so, the system just hangs or freezes.
I have updated the link in tools,database utilities, file manager and I have

When I create a link to a .csv table that includes names that have accents,
it changes the accents to letters or weird characters in the Access table.  
I've tried through the specs using the language and code page.  The database
is Access 2003.  Thanks.

I have a Access 2002 Linked Table Access file that is linked to an Excel
2002 workbook,
The workbook was on Drive (H) but has been changed to F: Drive.
Now when I open my Access file it says its not a valid path. How can I solve

Looking to run and link from access to QMF for windows any one kow how

Hi all, I have a memo field in a query (Access 2003 / WinXP) that I am
trying to export to Excel. When I do the export manually, it exports
the column fine, with nothing being truncated. However, when I use a
macro to do the export (Output To Excel 97-2003) the memo field gets

I have some data in Excel that includes simple formatting including italics
and boldface. Now that Access 2007 memo fields support rich text, I would
like to use Access for this application instead of Excel.
When I import the data from Excel into Access 2007, the formatting ...

I have a text file that I am importing into Access.  All fields populate
correctly except for the date fields.  They import as text "06082007" and
need to be a date filed like 06/08/2007.  I have tried changing the field
property before and after import, appending the text filed ...

Hello -
I have three tables that are linked to eac other by ID numbers. Example,
Family Table has an ID, and the children have their own ID, but are linked to
the Family via the family ID.

I have simple import routine that pulls any txt file from a selected folder
and uses an import spec I created puts the txt file into a table I created in
Access. What is the best way to filter out bad records during the import.
Right now I use a delete query and just delete any ...

I am importing Excel data into an Access database, and everything is working.
I am using "DoCmd.DoMenuItem acFormBar, acFile, 2, 1" to start the import in
a module.
The problem is that the file open dialog defaults to "my Documents" and a

I have an Excel spreadsheet which contains formatted text -- italics and
boldface. Since Access 2007 supports rich text, I would like to move the data
to Access.
When I do an import from Excel 2007 into Access 2007, I lose the text

I have a Word 2000 template that I convert to a txt file to import
data into Access.
Two different areas are giving me problems.
First is a check box that whether it's checked or not does not show

all of a sudden when i burn cd's, my computer does not burn using cd-+R. but
if I give make two copies and then insert cd-rw, then in the second copy iy
burns on cd-=r. how to correct this problem?

I have text files given to me to be imported into a database table.  This is
a new database application but I'm having some problems with the files.  They
are .htm files but if I use the get external data for htm the error report
says the file contains no data.  Most lines in the ...