Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / April 2004

Tip: Looking for answers? Try searching our database.

NULL and Empty String

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MST - 30 Apr 2004 08:43 GMT
Hi all,

I need to import data from a Excel file into Access Table.

A column in Excel file is empty and then imported into
Access Table it default becomes interpreted as NULL.

Any suggestion to get the imported field into Empty String
rather than NULL.

Thanks
Ken Snell - 30 Apr 2004 13:06 GMT
You cannot convert values as you import them. But you can manipulate them
after you have imported the values.

Import into a temporary table, and then use an append query to copy the data
into a permanent table. In that append query, use a calculated field to
convert a Null value into an empty string ("").

Signature

       Ken Snell
<MS ACCESS MVP>

> Hi all,
>
[quoted text clipped - 7 lines]
>
> Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.