By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,784 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

ListDatabase to Access

P: 2
I have almost the same issue like in post "Help With Converting List to Database" but with some additional differences.

So I have the following list:

HEADER
NAME=John Smith
BITHDATE=19.06.1980
ADDRESS=123 Anystreet
TELEPHONE=333-555-1212
FAX=333-555-2121
NAME=Dave Jones
BITHDATE=19.07.1979
ADDRESS=321 Main Street
TELEPHONE=444-555-1234
FAX=444-555-4321
[...]

? Is there a possibility to convert this list into access table (column form) to take into consideration that COLUMNNAME=FIELDRECORD and between list records can be some additional text headers which should not be imported.

Thank you very much.
Vadim
Oct 18 '06 #1
Share this Question
Share on Google+
2 Replies


PEB
Expert 100+
P: 1,418
PEB
Hi Vadim,

It is possible.... With Vb or without VB...

If without VB you need to add a complementary column before or after each row that indicates the number of record... So the first 10 rows will have as number of record = 1 the second 10 = 2 and so on...

Finally you have to import your table as text delimited file with delimiter "="

And you'll have 3 columns....

To obtain your table you need to do a crosstab query.. as column value you choose the column with fields and as value the first seen value from the column with values...

Remember to group by also number of record..

Finnally you'll have a query that shows the number of record, and the values from the respective record...

You need to save this query

Create new one based on the previous crosstab and Choose as query type - Make table query...

Run it!

This is the last step :)

Best regards

Vladimir
Oct 21 '06 #2

P: 2
First of all thank you for your feedback Vladimir.
Well, I'll be very happy to have the third column which indicates the record number but unfortunately I don't have it. And I really don't know how to make it because the external file contains two tables one under another fortunately the column names are not the same between them e.g.

NAME=John Smith
BITHDATE=19.06.1980
ADDRESS=123 Anystreet
TELEPHONE=333-555-1212
FAX=333-555-2121
[...]

NAME1=John Smith
REQUESTDATE=23.10.2006
APPROVEDDATE=
WORKDURATION=
DEADLINE=
[...]

The steps behind is very clear for me, thank you. I think only VB code can save in such situation.
All suggestions will be grateful.
Oct 23 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.