FreePint: Join
Join FreePint and receive the Newsletter every two weeks for free.
Join now »
|
|
|
If you find FreePint useful, please supply
a testimonial »
|
|
FreePint Family:
Monthly magazine reviewing business information products »
Articles, tools, and a monthly magazine, to give you practical help with information skills »
Recruit for information-related roles, or find your next challenge. »
Daily update of web-based resources »
Daily update of free, full-text reports »
|
|
|
|
Home > Forum > Bar > Message |
|
|
Join FreePint and receive the twice-weekly Bar Digest and twice-monthly tip-packed Newsletter. It's free. [ more ]
|
|
|
|
The FreePint Bar is generously sponsored by Dow Jones Factiva.
|
|
|
| Start New | Message Index | Flat View |
| Problems with MS Access |
| Author: | Kate Worlock |
| Date: | Monday, 8th Oct 2001 18:12 |
| Views: | 2,448 (excluding Digests and RSS feeds) |
| Category: | Computers and Software | | URL: | http://www.freepint.com/go/b13267 |
|
Hi Free Pinters,
A little conundrum which is taxing me, but to which some bright spark out there no doubt knows the answer(fingers crossed!).
I'm trying to export an Access database into a comma delimited file format, which has been fine, but when I try to import this file back into Access it throws up a bunch of error messages and won't let me do it. I even tried going via Excel, but to no avail. There must be a way to do this - after all, I haven't done anything to the comma delimited file which came straight out of Access in the first place!
Yours in desperation, and grateful for any help,
Kate |
|
| Start New | |
| Topic |
Author |
Date |
ID |
 | Problems with MS Access | | Hi Free Pinters,
A little conundrum which is taxing me, but to which some bright spark out there no doubt knows ... |
|
Kate Worlock |
08/10/01 18:12 |
13267 |
 | Re: Problems with MS Access | |
The trouble with CSV files
is that values or fields are separated by commas.
If you have commas in your text,
this ... |
|
Penny Bailey |
10/10/01 14:06 |
13303 |
| | Re: Problems with MS Access | | Kate can't see what's wrong, but starting from scratch...
right click over the table you want to export and select Export, ... |
|
Steve |
09/10/01 10:22 |
13276 |
|
Kate Worlock |
10/10/01 10:51 |
13294 |
| | Re: Problems with MS Access | | My database source exports data field delimiters as commas, semicolons, or dashes -- check with your DB: what designates the ... |
|
Edward W. Stollery II |
13/10/01 04:08 |
13362 |
| | Re: Problems with MS Access | | It sounds like your text fields are not being delimited correctly.
- Are you losing the quotes around text fields?
- ... |
|
Chris |
10/10/01 13:20 |
13301 |
|
Steve |
10/10/01 10:56 |
13295 |
Please note: The reply form is not showing because the posting is older than six months or the thread is locked. Please start a new topic or contact the forum administrator.
|
|
