MySqlTalk.com  

Go Back   MySqlTalk.com > Navicat - MySQL management tool > Navicat Support
User Name
Password
FAQ Members List Calendar Search Today's Posts Mark Forums Read


Reply
 
Thread Tools Search this Thread
Old 05-30-2006, 05:07 AM   #1
gneiterl
Junior Member
 
Join Date: May 2006
Posts: 1 gneiterl is on a distinguished road
Navicat - Import : Hard Values?

Hi all,

i have a little ( or i think BIG problem ^^ ).
I want to import data in mein db with the import wizard ( txt-files, xls-files, whatever ).
I have my table with "clientId", "number" and "name" columns.
I want to import the number and name from the file, and i need and hard value in the clientId column. ( f.e. the complete importeted file should be for the client with id = 5 )

how can i realize this? is there a possibility to say to the import wizard: set the clientId always to 5 ( or 3 ot 5, should be variable ) and import the rest from the file?

plzz gimme some advise, otherwise im lost xD

greetings,
stefan schießl
gneiterl is offline   Fork this post Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Import after table changes ICE9 Navicat Support 1 01-28-2005 03:20 PM
Navicat (Windows) version 6.1.10 is now released NavicatGuy Announcements 0 01-11-2005 11:55 PM
Navicat (Windows) version 6.1.9 is now released NavicatGuy Announcements 0 12-17-2004 04:19 AM
Import special characters from Mac TXT file rmdrake Navicat Support 2 12-16-2004 09:12 AM
Import Access, Excel and data of other formats to MySQL by Navicat NavicatGuy Articles 0 08-17-2004 01:08 AM



All times are GMT -4. The time now is 08:24 PM.



Powered by: vBulletin, Copyright ©2000 - 2008, Jelsoft Enterprises Limited.
Google
  Web http://www.mysqltalk.com
DISCLAIMERS:
1. We have no commercial interest in this site.
Banner Ads and Subscriptions will only be used to help pay for hosting and maintenance costs.
2. MySQLTalk.com is NOT affiliated with MySQL AB in any way.
3. MySQLTalk.com is NOT endorsed by MySQL AB in any way.
4. Please do not post any content that is harmful to MySQL or MySQL AB, meaning no misleading or obsolete information will be tolerated.
Well-founded constructive criticism meant to help the community is permitted.
5. This website is founded with the goal of improving the MySQL community.
We not only tolerate newbies, we encourage them.
Please do not ask newbies to "read the manual".