excel - Access Export to Text File (Formatted files) then Import it issues -


my coworker , noticed issue trying import formatted file text file preduced using access export text file.

the sample file within access after create looks this: enter image description here

the sample file looks when exported using text file option:

------------------------------------------------------------------------------------------------------ |    id     |          famousname          |                        famousfor                        | ------------------------------------------------------------------------------------------------------ |         3 | bill gates                   | american businessman                                    | ------------------------------------------------------------------------------------------------------ |         4 | muhammad ali                 | american boxer , civil rights campaigner              | ------------------------------------------------------------------------------------------------------ |         5 | john f. kennedy              | president 1961 1963                               | ------------------------------------------------------------------------------------------------------ |         6 | christopher columbus         | italian explorer                                        | ------------------------------------------------------------------------------------------------------ |         7 | elvis presley                | american musician                                       | ------------------------------------------------------------------------------------------------------ |         8 | albert einstein              | german scientist, theory of relativity                  | ------------------------------------------------------------------------------------------------------ |         9 | paul mccartney               | british musician, member of beatles                     | ------------------------------------------------------------------------------------------------------ |        10 | leonardo da vinci            | italian, painter, scientist, polymath                   | ------------------------------------------------------------------------------------------------------ |        11 | pablo picasso                | spanish modern artist                                   | ------------------------------------------------------------------------------------------------------ |        12 | vincent van gogh             | dutch artist                                            | ------------------------------------------------------------------------------------------------------ |        13 | franklin d. roosevelt        | president 1932 1945                               | ------------------------------------------------------------------------------------------------------ |        14 | thomas edison                | american inventor                                       | ------------------------------------------------------------------------------------------------------ |        15 | ludwig beethoven             | german composer                                         | ------------------------------------------------------------------------------------------------------ |        16 | oprah winfrey                | american tv presenter, actress, entrepreneur            | ------------------------------------------------------------------------------------------------------ |        17 | walt disney                  | american film producer                                  | ------------------------------------------------------------------------------------------------------ |        18 | neil armstrong               | astronaut                                            | ------------------------------------------------------------------------------------------------------ |        19 | j.k.rowling                  | british author                                          | ------------------------------------------------------------------------------------------------------ |        20 | ernest hemingway             | american author                                         | ------------------------------------------------------------------------------------------------------ |        21 | henry ford                   | industrialist                                        | ------------------------------------------------------------------------------------------------------ |        22 | steve jobs                   | co-founder of apple computers                           | ------------------------------------------------------------------------------------------------------ |        23 | ronald reagan                | president 1981 1989                               | ------------------------------------------------------------------------------------------------------ |        24 | babe ruth                    | american baseball player                                | ------------------------------------------------------------------------------------------------------ |        25 | billie holiday               | american jazz singer                                    | ------------------------------------------------------------------------------------------------------

which fine , easy read when try import txt file access never goes though access created it!:

enter image description here enter image description here enter image description here

i tried use | delimiter resulted in odd table layout (notably --------- being in first column , others still not having header names , all. enter image description here enter image description here

after going through a lot of configurations comes out looking this: enter image description here

or other type of formatting looks terrible.

although not big deal since there other formats export/import (namely 1 use - excel) coworker , find out if it's @ possible import txt formatted file version since access offers option... , seem use should work others do.

reading this microsoft office guide exporting in access: enter image description here


-

Comments

Post a Comment

Popular posts from this blog

python - How to insert QWidgets in the middle of a Layout? -

Image
i'm using qt framework build graphical user interface. use qgridlayout position qwidgets neatly. gui looks this: my application regularly adds new widgets gui @ runtime. these new widgets not added @ end of qlayout, somewhere in middle. the procedure bit cumbersome. applied on figure above, need take out widg_c , widg_d , ... qgridlayout. next, add widg_x and widg_y , , put other widgets again. how remove widgets qgridlayout: for in reversed(range(mygridlayout.count())): self.itemat(i).widget().setparent(none) ### as long you're dealing small amount of widgets, procedure not disaster. in application display lot of small widgets - perhaps 50 or more! application freezes second while procedure ongoing, annoying user. there way insert widgets somewhere in qlayout, without need take out other widgets? edit: apparently solution qvboxlayout simple. use function insertwidget(..) instead of addwidget(..) . docs can found link: http://doc.qt.io/qt-5/qboxlayou
Read more

python - serve multiple gunicorn django instances under nginx ubuntu -

i need serve 2 webs apps (django) on gunicorn under different domain names using nginx on ubuntu. started using tutorial: https://www.digitalocean.com/community/tutorials/how-to-set-up-django-with-postgres-nginx-and-gunicorn-on-ubuntu-16-04 it worked fine 1 using that. tried same thing second gives me 502 gateway second domain. tried following tutorial: http://michal.karzynski.pl/blog/2013/10/29/serving-multiple-django-applications-with-nginx-gunicorn-supervisor/ i'm @ part run gunicorn start script: sudo bin/gunicorn_start i response: starting webuildblack root traceback (most recent call last): file "/home/devin/webuildblack/bin/gunicorn", line 7, in <module> gunicorn.app.wsgiapp import run importerror: no module named 'gunicorn.app'; 'gunicorn' not package you have named program gunicorn.py gunicorn -package. rename file , remove gunicorn.pyc file.
Read more

module - Prestashop displayPaymentReturn hook url -

i new prestashop developer , trying create paymentmodule. have got show payment method can not proceed purchase because not know hot works. does know should redirect run hooddisplaypaymentreturn method? i happy if explain me complete navigation map make purchase. anyway, can find relation between hooks , pages? when have new module payment rely on simplest provided prestashop: bankwire. inside can find 3 hooks. hookpayment: public function hookpayment($params) { if (!$this->active) return; if (!$this->checkcurrency($params['cart'])) return; $this->smarty->assign(array( 'this_path' => $this->_path, 'this_path_bw' => $this->_path, 'this_path_ssl' => tools::getshopdomainssl(true, true).__ps_base_uri__.'modules/'.$this->name.'/' )); return $this->display(__file__, 'payment.tpl'); } hookdisplaypaymenteu: public fun
Read more