Convert Excel spreadsheet data to Access (ver 2002)

C

CYork

I downloaded and installed the AccessLinks add-in to Excel
and have loaded it in Excel. When I try to export a
typical spreadsheet to Access I get either a single cell
in a database or a few cells from the top line (titles)
and then a message saying that the data can't be imported
into Access.

Does the Excel data need to be in any certain format?

CYork
 

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

Linking data in MS Word into Excel 5
Accesslinks function 2
Updates for excel 2002/3 0
Converting excel to PDF, single page converts to multiple HELP! 1
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Macros to convert Data into date format and then plot in graph 7
forms, data import excel, generate multiple pages 2

Top