Author ICNJill on 07-09-2002 at 01:25 (EST)
|Okay.. here's a bonehead question. I would like to import my data and have done it successful just using notepad and creating the file that way. The problem is that it's a sucky way to do it. I couldn't figure out how to save file made in access as a flat file database that imported correctly?? How about in excel??? How do people normally prepare the file?? Just with notepad.. or what. |
The instructions that came with it didn't help at all with respect to which programs to use to create the file, if any? I'd love to use something other than notepad. Any suggestions? Please email me your answer.
|Messages In This Discussion|
| 1. RE: Importing Data|
Author Bill Weiner on 07-09-2002 at 04:50 (EST)
|You really should be able to use any program... such as MS Access or MS Excel to create the import data file.... just as long as the import data file is in the bar-delimited format described in section 8 of the uStorekeeper User's Guide:|
If the data is not being imported, then you may want try opening the Access/Excel-generated file with a text editor and see where the formatting is wrong.
| 2. If only it were that easy|
Author Jill on 07-09-2002 at 22:43 (EST)
|Okay... so I've tried Access and Excel and the problem is that none have a bar delimited format. Yes, I can find comma, tab or space. But no bar-delimited. |
So... how should the file be saved in any of these programs to reach the bar-delimited format???
| 3. RE: If only it were that easy|
Author Bill Weiner on 07-10-2002 at 06:47 (EST)
|I'm pretty sure there is a way (possibly in a Template Wizard??) where you can specify the delimiter to be any character you want. (Although, I just spent 5 minutes with Excel and didn't see it.) I guess worse-comes-to-worse, you could use a tab-delimiter and then do a search-and-replace on the generated file to change the tabs to bars. Kind of a pain, but....|
Also, if you do use some intermediate delimiter, you'll probably have to use tabs... because commas and spaces will probably interfere with the uStorekeeper data.
| 4. What do other clients use?|
Author Jill on 07-10-2002 at 13:28 (EST)
|FYI... What do other clients use to generate their data files??? Cause, if you couldn't see it, and I couldn't see it... well then... we're both missing something. I did the search and replace and it didn't work easily. Not worth doing as it added a variety of extras that needed to be tweaked out.|
Surely, there's an easier way, eh?
| 5. RE: What do other clients use?|
Author Bill Weiner on 07-11-2002 at 06:01 (EST)
|I'm not that familiar with all of the features and utilities of MS Access and MS Excel .... so maybe someone else out there will answer your question on how to export data from those programs with "bar" delimiters?|
In the meain time, if you export with the "tab" delimiter and then do the search-and-replace with the "bar" character... just be sure to do a "Replace All". That shouldn't be difficult.