importing excel 97 srpeadsheets to access 97 
Author Message
 importing excel 97 srpeadsheets to access 97

i'm importing spreadsheets (using docmd.transferspreadsheet) from excel 97
into an access 97 db, and i get the following error :

microsoft access was unable to append all the data to the table.  the
contents of fields in 0 records were deleted and 0 records were lost due to
key violations

i've noticed that part of the problem is cells in the excel spreadsheet that
contain lots of trailing spaces, but i've fixed those, and now some sheets
int the workbook work fine, but others are still doing it.  any ideas?


trevor steinberg

Fri, 11 Jan 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Import from Excel 97 to Access 97 table

2. Importing select Excel data into Access 97 tables

3. Import Excel files into Access 97

4. Import From Excel 2000 with VBA code into Access 97

5. urgent!!!!!!!!!How to import comment from excel spreadsheet to access 97

6. import Excel to Access 97 w/ VB

7. Import Excel data into a BD Access 97 wiyh Visula Basic 5.0

8. import excel to Access 97 by using adox

9. vba code to copy table from access 97 to excel 97

10. Automation Problem with Access 97/Excel 97

11. Urgent : Exporting Access 97 data to Excel 97

12. Sending and manipulating data from Access 97 to Excel 97


Powered by phpBB® Forum Software