Excel to Access

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

When I copy paste several columns/rows from Excel to Access the process
copies the Excel column headings into Access as the first row.

How can I avoid this?
 
From inside Access, in the database window, use File | Get External Data |
Import ... -- during the import/wizard process, specify that you don't want
the headings.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
use the get external data import wizzard - there is a check box that invites
you to use first row as headings - uncheck this box and click next.
 
Sorry, I had the direction backwards. I meant copy/paste Access to Excel.

Ed
 
From Access, File | Export ...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How can I import an unstandard Excel worksheet into Access 2007? 3
moving data from excel to Access 4
Excel Help to copy information from one row at a time to another sheet 1
Access #Error & Excel Pivot 0
Excel Access - importing an excel spreadsheet 0
Copy Excel Data to Access 1
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top