I have imported some csv files into some tables in my Access database. I want
to find out the names of those files, where can I look? The reason I want to
know is that I have similar looking files and am not sure which one I
imported into existing tables. For eg: Mar06 and ...

I exported some data from an Acces97-query to an Ecel97-sheet. In the
excell-sheet the figures are changed. For example, a field that containes
1503.6 (not a calculated field) in Access, now shows in Excell
1503,59997558593. What is the cause of this and, more important, waht is ...

I really need help.  I'm using a bunch of Access db which all have tables
linked through ODBC.  When I create the link, I often am prompted to set the
Primary Key(s) for that table.  
Now I'm finding that sometimes when I go back into a linked table the

i have a database i am trying to use a set of excel spreadsheets in. each
sheet is data pertaining to a specific machine we have built. i am trying to
use these excel spreadsheets that each part of each machine is built of to
combine into my database.

I have written a VBA proc to load data from a xls, but I seem to have a
problem.  Some (4) of the fields are text fields that contain either TRUE or
FALSE.  I have the table design set to TEXT for these columns, but the values
inserted are -1 and 0.

I really  need help, i am not familiar with VB. I have a text file with
headers, here is an example
Header:
Agent  ID ACD bcd Calls Avg work Hours Avg Calls per Hous Avg after call

I'm trying to create a survey form.  I will use Adobe Acrobate to convert it
to a pdf file, which is easier to send, but I want the fields used for the
answers to correlate to my database, so that I don't have to re-enter the
information.

I searched and could not find a viable solution to my issue:
On a daily basis, I can receive a different version of an Excel
spreadsheet to be imported into an Access database.  Basically, I want
to take any version of the spreadsheet, look up a column and then copy

Dear Sir or Madam:
I have huge ammout of data (about 250M) in a text file and cannot be open in
excel since the maximum row number exceeds excel maximum row number  limit.
When I tried to import external data(both in .txt and .xls formats) using

in XP, when entering data into worksheet cell, that cell  is now expanding
into cell above thus obscuring any data in that cell ~ solution please.

Is it possible to do create a macro within Access to import a text file where
the file name changes daily ie there is a dialogue box where the user can
select the file required.
Any help would be much appreciated?

I need some help on how I can do this. What I need is some VBA code
which would help me retrieve all records for yesterday which of course
I can query with Date()-1, and then
1) Add these records to a Table1 in another database (Note: Table1

I need to export spreadsheets from Access based on a series of queries. The
data looks like this in access:
Table in Access
UserID Data1 Data2 Data3

I recieve a number of unrelated tables from the internet which are usually
updated monthly or quarterly, and which i copy and paste into excel.  These
tables typically have the date as row headings and various different 'items'
as column headings (ie. workplace absences per month ...

I have a number of Excel workbooks that all contain at least 4 worksheets.
The information in each worksheet is the same layout just different values
of data from different companies. The worksheet looks something like this
....................Type1................Type2........... ...