I have 2 databases with the same tables.  I need to merge the data from
database 2 into database 1.  I created an append query but I keep getting a
"not enough space on temporary disk" error.  I even limited it down to 3
months worth of data and i still get this error.  if i ...

I have a dbase 5 file that contains 46,873 records. When I import the file,
all 46,873 records show up but when I link to the file I only get 730
records. Importing this file takes a very long time so I'd perfer to link to
it instead.

I am hoping someone out there can help me.  I importing excel spreadsheets
into an access database.  The excel files will be updated monthly so I am
linking them.  However, when I do link them, for some reason the data type
changes and I get mismatch errors when I run queries.  I ...

does anyone know how to import the data and set up a contact list

I am trying to import text delimited file produced by external system.  
This file contains data starting from row 10, first 9 rows contain some
tiltes and blank lines.  If I remove first 9 rows, my import works perfectly.
How can I have data imported from that file starting at row ...

Hi everyone, I'm new to this forum and beforehand, I'd like to thank everyone
for any help received.
I have searched the archives and read a number of links within them and I
can't figure out how to export a qry to xl.

I am trying to design a software in MS Access for my own use regarding
Customers, Orders & payments. I need a sample file to refine my knowledge. If
anyone can direct me I will be grateful.
Best regards,

I use an ADO connection to add new records to a SQL Server database. After a
new record is added iit is supposed to be the current record. Yet, I cannot
seem to retrieve the primary key (autogenerated) for the record. I just get a
zero. The added data goes in and can be queried ...

Successfully imported contacts from my office computer (which is connected to
a LAN) to a new home computer, but the record of emails and notes, etc. under
"activities" did not import. Using MS office 2003 & Outlook 2003 & Windows XP
on both computers.

HI experts,
Appreciate if someone can help me on this. Is there any fastest way to export
a table to multiple excel files. I got one field name codes eg 100....250.
Can someone show me how to export data with code 100 to 100.xls.....code 250

While in Excel I have changed my 10 digit account numbers into text format,
and then I import them into Access.  Frequently, these numbers do not convert
correctly.  They get converted into scientific notation and the trailing
numbers are lost.  While converting Excel into Access ...

I working on a project that uses single cell data for access to fill out
single cells in Excel. Everytime I try and and add the "GET EXTERNAL DATA" to
my Excel Template it wants to add the whole query rather then just single
cell information.

We've been using a macro to import Excel spreadsheets into an access 2002
database. After 5 months of this we found an error on a report. It turns out
that access is ignoring the last row and last column of the spreadsheet. If
the spreadsheet has 12 columns and 1000 rows the table ...

The formula bar has disappeared from my Excel page, even for new sheets.
It's not in toolbars.
Any ideas?

I am new to Access 2003. I have two tables with identical fields. What is the
easiest way to copy or merge the records from one table into the other. I
tried "cut & paste" but that didn't work.