Import Excel file in Access 2003

F

frankie.lau

Hi all,

I've an existing Access 2000 program that running on Windows XP + Office
2003. All functions are running well, same as in Windows 2000 + Office 2000,
except function to Import Excel file (where HasFieldNames set to FALSE).

In Windows / Office 2000, the import function is able to import column with
General & Date/Time formats (as Text in Access table). e.g. cell D2 is
General, D3 is Date/Time and both of them were blank.

However, in Windows XP / Office 2003, Access prompts "... Access was unable
to append all the data to the table. ... record(s) were deleted ...".

In other posts, it may be the difference of format conversion between Office
2000 & 2003. And I'd like to know if there's solutions other than type a
dummy string, e.g. " " (space) in the Excel file.

Thanks a lot!
Frankie
 

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

Access 2003 and excel 0
Access 2003 versus Access 2007 Excel Import 0
Import mutiple name text files into Access 2003 1
import external data as a List (not table) into excel 2010 with excel 2000-2003 list format 0
Excel Import Specification 2
Access 2000 issue opening an Excel 2007 worksheet 0
Transferspreadsheet import conflict 3
Importing spreadsheets in Access 2000 1

Top