UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
2 Pages V < 1 2  (Go to first unread post)
   Reply to this topicStart new topic
> Import Csv File With Parameters, Access 2013    
 
   
Phil_cattivocara...
post Jul 21 2019, 01:59 AM
Post#21



Posts: 318
Joined: 2-April 18



Is it the same file just with another extension or is it a total different file, with another structure? Did you try to rename it as .txt?
Can you create a table linked to the csv file? If yes, try to create a classic append query with QBE.
Verify if CaseKey is recognised as text or numeric. If numeric you have to change this
CODE
... = '100332') ...
without apostrophe.

--------------------
Please forgive in advance my horrible English.
Go to the top of the page
 
WongMeister
post Jul 21 2019, 01:42 PM
Post#22



Posts: 1,563
Joined: 17-June 02
From: Redondo Beach, CA


PHIL!!!!

You did it again! Thanks.

To answer your question, it is a different file, with a different structure (versus simply putting a txt extension).

When I created the csv file, it changed the format of the CaseKey value to a number, instead of keeping it as a txt (as in the txt formatted file). I had spent a 2-3 hours on the internet looking for solutions before I decided to come back to UtterAccess.

This is great!!!!!

BOOYAH!!!! (Here is another example of great joy we use in the USA.)
Go to the top of the page
 
Phil_cattivocara...
post Jul 21 2019, 11:25 PM
Post#23



Posts: 318
Joined: 2-April 18



QUOTE (WongMeister)
You did it again! Thanks.
thumbup.gif

--------------------
Please forgive in advance my horrible English.
Go to the top of the page
 
2 Pages V < 1 2


Custom Search


RSSSearch   Top   Lo-Fi    19th August 2019 - 09:58 PM