Visual Basic Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsProgrammingVisual Basic Programming

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old December 27th, 2004, 06:23 PM
Mat Mat is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Dec 2004
Posts: 23 Mat User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 11 m 22 sec
Reputation Power: 0
Export table and re-importing

Hi
I have a need to export a table to some of my remote users who will then need to import
the data to update their database. I presumed to use the following:
DoCmd.TransferText acExportDelim, , "tblSchedule", "C:\Out\schedule.txt"
This works fine now, but problems occur when trying to import it. I use Importdelim, but get error 2391 Field F1 does not exist in destination table tblSchedule.
Surely if I what I import should be same as what I export ?
Any help to work this out would be appreciated.
Thanks

Reply With Quote
  #2  
Old December 27th, 2004, 08:52 PM
lewy's Avatar
lewy lewy is offline
Alter Ego Wizard
Click here for more information.
 
Join Date: Jun 2004
Location: Edinburg Tx
Posts: 4,384 lewy User rank is General 8th Grade (Above 100000 Reputation Level)lewy User rank is General 8th Grade (Above 100000 Reputation Level)lewy User rank is General 8th Grade (Above 100000 Reputation Level)lewy User rank is General 8th Grade (Above 100000 Reputation Level)lewy User rank is General 8th Grade (Above 100000 Reputation Level)lewy User rank is General 8th Grade (Above 100000 Reputation Level)lewy User rank is General 8th Grade (Above 100000 Reputation Level)lewy User rank is General 8th Grade (Above 100000 Reputation Level)lewy User rank is General 8th Grade (Above 100000 Reputation Level)lewy User rank is General 8th Grade (Above 100000 Reputation Level)lewy User rank is General 8th Grade (Above 100000 Reputation Level)lewy User rank is General 8th Grade (Above 100000 Reputation Level)lewy User rank is General 8th Grade (Above 100000 Reputation Level)lewy User rank is General 8th Grade (Above 100000 Reputation Level)lewy User rank is General 8th Grade (Above 100000 Reputation Level)lewy User rank is General 8th Grade (Above 100000 Reputation Level)  Folding Points: 1009 Folding Title: Novice Folder
Time spent in forums: 1 Month 1 Week 1 Day 23 h 46 m 19 sec
Reputation Power: 1488
Are you exporting your file using a delimeter ie. | or , ? You need to make sure that for every field, you have this delimeter.
Example: firstname|lastname|middlename|

All your fields must have this delimeter including the last one.
If you do the following: firstname|lastname|middlename
A carriage return character will get appended to your text file and access will try to interpret this character as another column.

Reply With Quote
  #3  
Old December 28th, 2004, 07:19 PM
Mat Mat is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Dec 2004
Posts: 23 Mat User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 11 m 22 sec
Reputation Power: 0
Exporting/Importing text

Hi
Yes, it is comma delimited and all fields appear to be matched OK.
Any ideas ?
Thanks.

Reply With Quote
Reply

Viewing: ASP Free ForumsProgrammingVisual Basic Programming > Export table and re-importing


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway
Stay green...Green IT