PC Review


Reply
Thread Tools Rate Thread

Determining data type of imported data

 
 
=?Utf-8?B?Sm9lQTIwMDY=?=
Guest
Posts: n/a
 
      19th Jun 2006
I am working with an Access application that requires importing Excel Data
into an exisiting table. The new data overwrites the old data each time, but
for the application to work it has to use that existing table with columns
with data types, Text, Date, Number. Sometimes the data from excel imports as
Number in the first column even if it is formatted as general or text. Is
there a work around for this, or is there a way for the app to compare the
two datatypes and switch the type if it is incorrect.
 
Reply With Quote
 
 
 
 
John Vinson
Guest
Posts: n/a
 
      19th Jun 2006
On Mon, 19 Jun 2006 13:23:01 -0700, JoeA2006
<(E-Mail Removed)> wrote:

>I am working with an Access application that requires importing Excel Data
>into an exisiting table. The new data overwrites the old data each time, but
>for the application to work it has to use that existing table with columns
>with data types, Text, Date, Number. Sometimes the data from excel imports as
>Number in the first column even if it is formatted as general or text. Is
>there a work around for this, or is there a way for the app to compare the
>two datatypes and switch the type if it is incorrect.


Two suggestions:

- Don't directly Import the spreadsheet; instead, link to it, and run
an Append query loading your (correctly datatyped) Access table.

- If necessary, put a dummy row at the top of the spreadsheet with an
unambiguous text field ('X for example) above each such column.

John W. Vinson[MVP]
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
The type conflicts with the imported type David Jackson Microsoft ASP .NET 4 28th Apr 2009 09:38 AM
Determining if one type inherits from another type DamienS Microsoft C# .NET 7 25th Aug 2008 08:03 AM
Determining resolution of imported image? Nolan Haims Microsoft Powerpoint 3 25th Apr 2007 02:10 PM
The type '_Default' conflicts with the imported type '_Default' Wayne Brantley Microsoft ASP .NET 3 21st Dec 2005 01:41 AM
Imported contacts are not imported matt Microsoft Outlook Contacts 1 8th Oct 2003 08:48 PM


Features
 

Advertising
 

Newsgroups
 


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