Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
tim tim is offline
external usenet poster
 
Posts: 105
Default Data Transfer

When i import a excel sheet to a access table in is not transfering all the data. Som rows don't get transfered and the error is "Type" as in the type of data is bad.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Data Transfer

Depending on how you are transfering the data, it could be
that values in a field in your Excel sheet are not of the
data type established for that field in the Access table.
For example, you have a column in the sheet for dates,
that is going into the field in Access for dates. If in
the sheet column there is a value that can not be made
into a date, it will not get added to Access.

-----Original Message-----
When i import a excel sheet to a access table in is not

transfering all the data. Som rows don't get transfered
and the error is "Type" as in the type of data is bad.
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Transfer tel Excel Discussion (Misc queries) 5 May 30th 08 04:33 PM
auto transfer data in sheet2 (selected data) deen Excel Worksheet Functions 1 May 9th 08 01:57 PM
Transfer Excel data into Word, including text box data Sarah (OGI) Excel Discussion (Misc queries) 0 July 13th 07 10:06 AM
can't transfer data Miguel Excel Discussion (Misc queries) 2 March 6th 07 07:28 PM
Transfer of data Cody Excel Discussion (Misc queries) 2 November 27th 05 07:31 AM


All times are GMT +1. The time now is 09:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"